Hel p insert days once a month has been selected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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,""
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Message box with days of month & date. 1
Link control to Excel cell to click a day in month to return date 3
Adding months to date at end of month 4
YEAR MONTH DAYS COUNTER 3
Use first day of month formula in a drop down list 3
Fill handle increments year instead of day 1
How do I do a drop down box with calender in excel? 4
Dates of a Day for a month & year cell formulas 2

Back
Top