Adding Series of Years, Months, & Days

**arthurbr** · 02-01-2008, 10:22 AM

To calculate difference between two dates try :
For the nr of years

=DATEDIF(A1;A2;"y")

For the number of months

DATEDIF(A1;A2;"ym")

For the nr of days :

DATEDIF(A1;A2;"md")

Where A1 is the begin date and A2 the end date ( change the semi-coloms to commas if necessary)
This is the method found here :http://www.cpearson.com/excel/DateTimeWS.htm

**daddylonglegs** · 02-01-2008, 12:14 PM

Trying to add text strings like "2 years, 3 months, 4 days" is unnecessarily complicated. Try using your base dates to calculate the total period as per my suggestion above.

**jmaitri** · 02-03-2008, 03:17 PM

Thank you for your help fellas!

I just had surgery, so will give your suggestions a go once I am feeling better and my mind is more clear!

Again, thank you and my apologies for not answering a bit quicker--I'll try all your suggestions in a couple of days and let you know I how I do.

With best wishes,
Jay

**jmaitri** · 02-04-2008, 11:30 AM

Daddylonglegs,

I just gave your solution a run and it worked like a champ! Many thanks for your help.

Likewise, thanks to everyone else who also lent a hand (formula)!

Jay

**eds_cortes** · 12-17-2011, 04:11 AM

Originally Posted by daddylonglegs

Trying to add text strings like "2 years, 3 months, 4 days" is unnecessarily complicated. Try using your base dates to calculate the total period as per my suggestion above.

Hello!
I know this post has been made years ago but i still hope for a reply. I tried your formula on a data which has two date ranges and it worked. Now i do not know how to do it with a data that has three or more date ranges. I tried adding another SUM command for each of the year, months and days (ex.=DATEDIF(Sum(A2,A4),SUM(B2,B4),SUM(C2,C4),"y")&"years",...) but Excel returns an error message about the formula being too long or there are too many entries.
Hope you could help me.
Thanks,
Eds

**gillawat** · 05-02-2018, 08:28 AM

Originally Posted by daddylonglegs

Trying to add text strings like "2 years, 3 months, 4 days" is unnecessarily complicated. Try using your base dates to calculate the total period as per my suggestion above.

It shows an error. The error is 2n-1 with n no. of values. The obtained value was 2n-1 less than actual value.
If I am wrong, can you please upload an excel sheet with an example.