CALCULATING DATES AFTER DATEIF

G

Glen

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
 
P

Peo Sjoblom

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)
 
Top