Automatically get all the dates of a month, entering specific year and month

**agios59** · 12-01-2012, 02:39 PM

In a sheet I enter the following:
... in A1 a year (say 2012)
... in A2 a month, formatting as "MMM" (JAN, FEB, MAR etc.)

How to automatically get in column A (say from A3) all the dates of the month entered, formatting as "D/M/YYYY" (e.g. 1/1/2012, 2/1/2012/ 3/1/2012, etc.)?
Thanks in advance

**dogberry** · 12-01-2012, 02:47 PM

Hi

Never used your version but if it has autofil use that

Chris

**Ace_XL** · 12-01-2012, 03:06 PM

Someone could come up with a shorter formula

In A3

Please Login or Register  to view this content.

Copy down

**benishiryo** · 12-01-2012, 10:50 PM

hi agios59, try:
=DATEVALUE(ROW(1:1)&$A$2&$A$1)

or if you need to show blanks when any months is less than 31 days:
=IF(DAY(DATE($A$1,MONTH(DATEVALUE($A$2&$A$1))+1,0))<ROW(1:1),"",DATEVALUE(ROW(1:1)&$A$2&$A$1))