How to calculate the date of birth with EXCEL? If anyone knows, please tell us.

Enter the date of the lunar calendar in cell A 1, with the format: 1974-6- 1.

Enter the formula in any cell: =MID ("pentaheptyl nonyl propyl pentaheptyl nonyl methyl propyl"), right (year (a 1), 1)+ 1,1)&; MID (The Ugly Son of Yin Mao, Tatsumi, Shen You and Xu Hai) noon, month (A 1),1)&; "the moon"

In addition:

1, the formula of annual trunk and branches you gave is problematic in a year with a mantissa of 9;

2. The year before the Spring Festival is incorrect (for example, today is still the year of Renchen, but it is already the year of Guihai with your formula)