Formula For Displaying Exact Days of the Month
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!
|