No, this is not correct. Try a few examples.


flummi wrote:
I guess Excel takes care of the fact that months have a different nmber
of days.

So when you you subtract date1 from date2 and the receiving cell is
formatted as e.g. dd.mm.yy then the result would read something like
11.23.02 which means the difference is 11 days, 23 months and 2 years.

Hans