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.
=================
