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

Also...

You can also enter the array formula,
=TREND({"6/26/01";"7/15/01"}+0,{1;20},ROW(1:20))
into cells A1:A20.