Autofill month formula

[kds001]

I want to have a formula that can be used to autofill the ones below based the month entered in cell A13. I have used "=DATE(YEAR(A13),MONTH(A13)+1,DAY(A13))" but I ran into a problem when I try to have that month be copied into a separate worksheet where the month is part of this concatenate function "=CONCATENATE("Month: ",'General Account'!A15)"


Is there a way I can enter the month in A13 such as January and the ones below will auto fill February, March, etc and then it be used in the concatenate formula I use above?

 

[Michael M]

If January is the only text in A13...simply click the little square in the bottom rh of A13 (when that cell is active) and drag down as far as you need

 

[Tom.Jones]

Write January in A13 then "drag" down till Decembre.