To get 23 years 6 months 5 days it must be 3 datedif functions concatenated
and not one so the 2 you are talking about might in fact be 6, you can add
the years, the months and the days separately

--
Regards,

Peo Sjoblom

(No private emails please)


"Glen" wrote in message
...
Is there a way to add the result of two dateIf functions. the result for
eact
is like this (23 years 6 months 5 days ) can I add this from one sheet to
the
same kind of result from another sheet. Thanks for your help