Months of the year

**Sammitry** · 05-09-2012, 05:16 AM

Can I set Excel so that if I put a month in a particular cell, say A1 (January), A2 - A12 will automatically follow with Feb - Dec etc... and if I then changed A1 to March the reast would update with April onwards??

**Richard Buttrey** · 05-09-2012, 05:24 AM

Hi,

Yes if you enter a proper date in A1, e.g. 31/1/2012, (format it as mmmm if you just wish to see the month name), then in A2 and copied down add the function

=EOMONTH(A1,1)

**Sammitry** · 05-09-2012, 05:38 AM

Don't worry, I got the formula wrong!! Your suggestion works perfectly - thank you!!
Can I also make this work so I see month and year? e.g. Jun-12? ( I tried format mm/yy) but the next cell A2 changed to Feb-00?

Originally Posted by Richard Buttrey

Hi,

Yes if you enter a proper date in A1, e.g. 31/1/2012, (format it as mmmm if you just wish to see the month name), then in A2 and copied down add the function

=EOMONTH(A1,1)