I'm making a monthly timesheet. I want the employee to be able to enter the start date and have Excel fill in the dates for the rest of the month.



I'm running into problems with months having fewer than 31 days because Excel fills in 31 days regardless. For example, June shows 06/01/16 though 07/01/16, and February shows 02/01/15 through 03/03/15.

How do I fix this?

Thank you!

Is it like shown in the attached?

Attached Files

Days_of_Month.xlsx (9.2 KB, 14 views)

Cross posted without links

http://www.excelguru.ca/forums/showt...s-of-the-Month

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post