In EXCEL tables, how to drop down and fill in the lunar calendar, for example, A 1 is the first day of the first month, and A2 can be automatically filled in as the second day of the first month.

There are two ways to do this. One is stupid, but it doesn't need an auxiliary column. There is a "custom sequence" in EXCEL, such as 1 23, which can be filled in because it is in the system by default.

So,

Method 1: Set the custom sequence.

2003 Edition: Tools-Options-Custom Sequences

2007 or 10: Office Button-excel Options-Common/Advanced-Edit Custom List-Enter Sequence-OK.

Method 2: For the formula, you need to set a date, such as 20 12- 1-23, which is the first day. You write it in A2, and then enter it in B2.

= text (a2, "[dbnum1] [$-130000] m month"&; IF( - TEXT(A2，"[$- 130000]d ")& lt； 1 1, "Chu", ")&; TEXT(A2，"[db num 1][$- 130000]d "))

Ok, it's just the first day of January, hehe ~ ~