Chinese New Year

C

Charlotte E.

Is it possible to calcuate the date of the Chinese new year, by either
worksheet functions, or an UDF, if given the Georgian calendar year?

I.e.

If I pass the year 1978, the function should return 2 February 1978.
If I pass the year 1999, the function should return 15 Feburary 1999.

Etc... (what ever the date of a given year)


TIA,

CE
 
C

CellShocked

Is it possible to calcuate the date of the Chinese new year, by either
worksheet functions, or an UDF, if given the Georgian calendar year?

I.e.

If I pass the year 1978, the function should return 2 February 1978.
If I pass the year 1999, the function should return 15 Feburary 1999.

Etc... (what ever the date of a given year)


TIA,

CE


Calculate... sure.

Chinese to Gregorian calc first, then a moon phase resolution.

A lot easier to simply paste in a pre figured list and reference that.

A calculation is harder, and then there are leap year complexities to
fold in.
 
C

CellShocked

Is it possible to calcuate the date of the Chinese new year, by either
worksheet functions, or an UDF, if given the Georgian calendar year?

I.e.

If I pass the year 1978, the function should return 2 February 1978.
If I pass the year 1999, the function should return 15 Feburary 1999.

Etc... (what ever the date of a given year)


TIA,

CE


Lookup table type:

http://www.mediafire.com/view/?tr2a8a06t7r64ox
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top