Hel p insert days once a month has been selected

E

ExcelDummie

i am creating a time sheet and want the days to fill down the sheet once a month has been selected from a drop down box in B2 want the dates of the month e.g 02/06 to fill down in column A7 to A37?
 
A

Andrew

Try this as one possible solution (?) :)

Link cell = B2

Enter below formula into cell A7 and drag down to cell A37

=IF(ROW()-6<=DAY(DATE(YEAR(TODAY()),$B$2+1,0)),ROW()-6,""
 
Top