CALCULATING DATES AFTER DATEIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Age Calculation 4
Datedif function 1
Dates 1
Counting years 2
exel"negative and positive days for creditors :formula 1
DATEIF 1
DATEIF Name error 3
Calculate months and years 5

Back
Top