MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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.

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

=========

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


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