Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

calculating dates

Posted by Connie on August 06, 2001 6:42 PM

I know this just has to have a simple answer but my brain for some reason I am hae hardest time figuring this out... is there a simple formula to calculate many dates at a time, without creating the simple(ie:) "6/5/2001"-"12/6/2001" for each date ?

Re: calculating dates

Posted by Cory on August 06, 2001 7:11 PM

I think you can find everything you need here:

http://www.cpearson.com/excel/datearith.htm

Go to the "search" link at the bottom of the page and put in "dates". There's a plethora of information here...:~0)
Cory

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.