MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calcuate dates within range of dates

Posted by Jessica Garcia on July 19, 2001 10:41 AM

Help, I want to create a timesheet that will automatically fill in dates between a certain range.
EXAMPLE: Period Starts 6/26/01 and Ends 7/15/01, can I get it to list all the dates in between those dates?

Posted by Mark W. on July 19, 2001 10:48 AM

See the Edit | Fill | Series... menu command.

Posted by Mark W. on July 20, 2001 2:15 PM


You can also enter the array formula,
into cells A1:A20.