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
Click to expand...


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
Click to expand...


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

Similar Threads

Need macro code to pick data according to year selected 1
Second Sunday in the month of May? 5
Mid-Month function help 5
please help me format this date to Month and Year 4
Test if a variable is given as array? 12
date corruption? 00/01/1900 2
week function in vba? 2
Sum all items from the given year 7

Top