Thanks but I tried that. for example: 2004/05/30 - 1986/06/24 returns
1917/12/06. actual answer should be 1917/11/06. it doesn't recognize zero
month.

"N Harkawat" wrote:

how about simply subtracting one from another
=B1-A1
where B1 holds the end date and cell A1 the start date

Why days360 unless you want to use 360 days per year convention.


"Dilly" wrote in message
...
Date360 gives an inacurate answer that over the course of 20 years can be
over a month. Is there an accurate way of computing the difference
between
two dates?