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.
