Dynamic Month Names

**sambo1982** · 03-09-2011, 07: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, 07:49 PM

Check out this

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

Thanks

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

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

Please Login or Register  to view this content.

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

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

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

or, if 'march' is in cell A9:

Please Login or Register  to view this content.

**DonkeyOte** · 03-10-2011, 05: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.