Graphical tutorial on converting Gregorian calendar date to lunar calendar in Excel

Time: 2020-04-26Source: Huajun Software TutorialAuthor: Aotuman

For those who have just learned Excel software, they may still have doubts about the operation of converting Gregorian calendar dates to lunar calendar dates, so what should we do? The following is the graphic and text operation content brought by the editor to convert the Gregorian calendar date to the lunar calendar in Excel.

Take the following table as an example. The left side is the Gregorian calendar and the right side is the lunar calendar. Fill in the function formula in the lunar calendar cell. =TEXT(A2,"[$-130000]yyyy-m-d")

1.jpg

A2 represents the Gregorian calendar cell to be converted, yyyy-m-d represents the format of the converted date, and [$-130000] is the key to lunar calendar conversion. Finally press Enter and fill it in.

2.jpg

If you think the format of this lunar calendar is not good-looking and does not have the characteristics of traditional Chinese display, then the formula can be changed: =TEXT(A2,"[$-130000]yyyy year m month"&IF(LEN(--TEXT(A2, "[$-130000]dd"))=1,"chu","")&"d"). Then press Enter to fill in the same way. In this way, the day of the month can be displayed.

3.jpg

The above article explains the graphic operation process of converting Gregorian calendar date to lunar calendar in Excel. I hope friends in need can learn it.

Related articles更多>>

Popular recommendations