auto fill dates

What's in the drop down? Month text? Short form? Long form? Month Number? Date?

Basically, you need to generate a date in cell A2 using what's in A1.
Then A3 to A32 just add 1 to the previous date. So, A3: =A2+1 and drag down.

For it to be neat, you should check that the month is the same and, if it's not, make it blank. For example, for February, you'd have 2 or 3 blank cells.


Regards, TMS

Put this formula in A2:

=DATEVALUE("01/" & A1 & "/" & TEXT(YEAR(TODAY()),"0000")) and format as a Date.


It generates a date using the first day of the month and the current year. It will accept and "valid" month or month number. So, for example, you can put 2, feb, febr, febru, ... february, and all will be accepted and generate 01/02/2013.


Regards, TMS