How to display lunar calendar date in excel table

The steps of setting the date of excel table as lunar calendar display are as follows:

1. Open the excel table to be operated, and enter the following functions in cell A 1: "= text (now ()," [$- 130000] yyyy-m-d ")".

2. A date can be observed in the cell: the first day of the sixth lunar month.

3. If you want to display the lunar calendar table completely, you can enter the following formula: =MID ("A, b, d, e, g, n, n ",mod (text (now ()," [$- 130000] e")-4,10. MID ("Zi Chou Mao Yinchen has applied for a letter at noon"), mod (text (now (), "[$- 130000] e")-4, 12)+ 1, 1) &" year. Text (now (), "[$-130000] [dbmnum1] m month d day").