how to calculate the substraction between two dates

  • Thread starter Thread starter =?iso-2022-jp?B?RVhDRUwbJEIhIRsoQk5FV1M=?=
  • Start date Start date
?

=?iso-2022-jp?B?RVhDRUwbJEIhIRsoQk5FV1M=?=

hi,

i have two cells ,in which there are two dates.
(for instance ,one cel l 08/02 ,the other 07/30)

if the gap of the two dates is 2 days , something will be set to do.

but it is difficult to judge the the substraction between two dates

any good ideas.

thanks
 
Perhaps this might be of help ..

Assume the *dates* "2-Aug-2004" and "30-Jul-2004"
are input in A1 and B1, and
A1:B1 is custom formatted as: mm/dd
viz. it'll show as:

In A1: 08/02
In B1: 07/30

Try in C1: =DAY(ABS(A1-B1))-1
Format C1 as: General or Number

C1 will return: 2
i.e. the number of days in-between the 2 dates in A1:B1
 
Try in C1: =DAY(ABS(A1-B1))-1


That method will work only if the difference between the two
dates is <= 31 days. Better to simply subtract one date from the
other, and format for General.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Chip Pearson said:
That method will work only if the difference between the two
dates is <= 31 days. Better to simply subtract one date from the
other, and format for General.
Click to expand...

Yes, you're right.
Thanks for the correction, Chip
... I goofed, plain and simple ..
 
Back
Top