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!