Adding up total years of expierence

Copper Contributor

I have used the DATEDIF formula to create a table with multiple employees years of expierence. Is is possible to now add all of those years of expierence (in Year, Month format) together for a group total?

 

For example I would like to add 22 Years 5 Months, to 5 years 6 months. 

3 Replies

@NeilRoback 

I'd add a separate column that returns the number of months using DATEDIF with "M" as third argument.

Let's say the results are in M2:M50.

Then use

 

=QUOTIENT(SUM(M2:M50), 12)& " Years, "&MOD(SUM(M2:M50),12)& " Months"

@Hans Vogelaar just had to change the periods to commas to make 12 the dividing number and that worked perfectly, thank you!

@NeilRoback 

Glad to see you were able to correct my stupid mistake! I have changed the periods to commas in my previous reply.