View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Sharad Sharad is offline
external usenet poster
 
Posts: 123
Default how do I subtract 2 date fields to get number of days elapsed?

Assuming that the dates are not more than 360 days apart,
you can use following formula, assuming date1 is in cell A1 and date2 is
is cell B1

=DAYS360(A1,B1)
If you do not want the formula to return a negative number,
and always return a positive number use

=ABS(DAYS360(H63,H64))

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!