Dynamic Month Names

**sambo1982** · 03-09-2011, 06:41 PM

I have a cell linked to a Access query which contains a stored month name. For example, the access user selects the starting month of a financial period. After inserting the starting month name (i.e. March) I would like the next 11 horizontal cells to fill in the next 11 months. I tried the date addition function with no luck. Any ideas?

**jambai** · 03-09-2011, 06:49 PM

Check out this

http://chandoo.org/wp/2010/04/06/rolling-months/

Thanks

**DonkeyOte** · 03-10-2011, 03:20 AM

If we assume A1 holds MARCH as a text string you might consider:

B1:
=UPPER(TEXT(DATE(1905,MONTH(1&A1)+1,1),"mmmm"))
copied across to L1

Note though the above is returning a string not a date per se.

**snb** · 03-10-2011, 04:03 AM

Use the autofill-grip (the cross in the right down corner of the cell)

or, if 'march' is in cell A9:

Sub snb()
  Cells(9, 1).AutoFill Cells(9, 1).Resize(, 11)
End Sub

**DonkeyOte** · 03-10-2011, 04:10 AM

The implication is that this needs to be dynamic though granted you could automate the AutoFill via Change Event - I confess that a formula approach seemed a little more obvious to me.