Month Formula

[msw]

Please advise me on how to write a formula that will start with January
2003, when I copy it to the next row it will increase the month to February
and so on. When I get to December 2003, the following month will be
January 2004.

Thank You

 

[JE McGimpsey]

You don't need a formula:

Enter

January 2003

in A1 and

February 2003

in A2. Select A1:A2 and drag the fill handle (lower right corner of A2)
down as far as necessary. XL will autofill.

If you want a formula:

A1: =DATE(2003,ROW(A1),1)

format as "mmmm yyyy". This will give you actual dates (e.g., 1/1/2003,
2/1/2003). If you want text only, use

A1: =TEXT(DATE(2003,ROW(A1),1),"mmmm yyyy")

and drag down.