China Naming Network - Auspicious day query - How to display lunar calendar date in excel table

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").