MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Start of a new day


Posted by Don S. on February 08, 2002 5:43 PM

How do i calculate the number of days between 2 dates? (ex. 02/01/02 - 02/08/02 (current date) : u can not count the current day or the last day). Excel seems to only increment the number of days at 12:00 pm instead of 12:00 am (start of a new day). In the previous date the number of days would be 6 at 12:01pm, but 5 at 11:55am

HELP!!!!


Posted by Aladin Akyurek on February 09, 2002 12:38 AM

Is it not

=B1-A1-1 [ where B1 is later than A1 ]

what you want?

The cell of this formula must be formatted as general.

==============

Posted by Don S. on February 11, 2002 2:49 PM

Posted by Don S. on February 11, 2002 2:52 PM


The reason that formula doesn't work is because I am trying to calculate the full days in between the dates. However the formula =B1-A1-1 will increment the next full day at 12:00 pm instead of the usual 12:00 am.

=================