Formula to sum the output from DATEDIF (X Years X Months X Days)

[DaveBre]

Hi all,

I'm currently using the DATEDIF formula below to work out the diffrence between two dates contained in B242 and C242.

=DATEDIF(B242,C242,"y")&" years "&DATEDIF(B242,C242,"ym")&" months "&DATEDIF(B242,C242,"md")&" days".

The output displays as X years X months X days which is fantastic for the end user reading the information.
Later in the sheet I need to sum a number of these outputs and again display that as X Years X Months X Days, but I can't get a formula to extract and sum the individual years, months and days.

Any ideas would be appreciated.

Thanks

Dave

 

[cyrilbrd]

cyrilbrd, thanks again. I've just tested the code and it works perfectly, I can see that I was missing the y / m / d from part of the formula.

Many Thanks

Cheers

David

Most welcome David, thanks for the feedback.
Glad it worked for you..

Cheers!