Use functions to convert Gregorian dates to lunar calendar in Excel2010

① start Excel2010, enter the following function in any cell: "=text (Now ()," [$-130000]yyyy-m-d ")".

② the cell immediately gets a date, as shown in the following figure, and the lunar date is the beginning of June. Although the result is a bit passable when you encounter a leap month, the February 9, 2010 Lunar calendar in the following figure should be December 26, but because of that year there was a leap May, the innocent more than one months. But it's a lot quicker than coding, and the leap month is not every day.

③ If you want to be fully displayed in the lunar calendar, you can enter the following formula: =mid ("Xing"), MOD (TEXT (now (), "[$-130000]e") -4,10) +1,1) &mid ("Kaniko has not been Shin Hai" in the afternoon, MOD (now (), "[$-130000]e") -4,12) +1,1 & "Year" &text (Now (), "[$-130000][dbnum1]m month D-Day")

④ for the various parameters of the formula, if you have questions you can leave a message, I will be with you to answer.