Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

Help ?Formula to count the number of days between to dates

Posted by Marc on December 08, 2001 3:31 PM
Anybody, is the a way to make a formula that counts the number of days , between to dates.
For example from 21-11-2001 to 08-12-2001.

Please help

Marc.


Check out our Excel Resources

Re: Help ?Formula to count the number of days between to dates

Posted by Aladin Akyurek on December 08, 2001 3:40 PM

=B1-A1

where B1 is the date later in time. Format the cell of this formula as General.

Aladin

=========


Re: Help ?Formula to count the number of days between to dates

Posted by Marc on December 09, 2001 1:32 AM



Re: Help ?Formula to count the number of days between to dates

Posted by Marc on December 09, 2001 1:32 AM



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.