Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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?

Re: Calcuate dates within range of dates

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

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

Also...

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.