How to fill in the lunar calendar date automatically in excel?

1, you can click the cell and enter the date directly.

2. Then select the cell, right-click and select Format Cell.

3. Set the format to "Date", then select a date style you like in the type on the right, and click "OK".

If you want to enter today's date, you can hold down the Ctrl key and press ";" Meanwhile. .

5. Note that after entering the date, you need to adjust the column width of the cell. If the column width is too small, multiple "#" symbols will be displayed.