date format

[doriannjeshi]

Hello,
I need the formula to convert the date formats like the one in A2, exp 22/02/2000 in (gregorian to chinese calender), only works for the a1 format

Test kua number.xlsx
	A	B
1	13-May-80	29 Mar 1980
2	26/08/1998	26/08/1998
Sheet2

Cell Formulas
Range	Formula
B1:B2	B1	=TEXT(A1,"[$-130000]d mmm e")

 

[rlv01]

I don't think a formula to convert gregorian data to the chinese lunar calendar will be easy to find.

The Structure of the Chinese Calendar

An explanation of how the Chinese Calendar is constructed and how it depends on the exact times of the northern winter solstice and dark moons.

www.hermetic.ch