View Single Post
 
Old 07-12-2016, 10:46 AM
ddhawks ddhawks is offline Windows 10 Office 2000
Novice
 
Join Date: Jul 2016
Posts: 1
ddhawks is on a distinguished road
Default 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!
Reply With Quote