Mar 27 2023 08:31 AM
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.
Mar 27 2023 10:03 AM - edited Mar 27 2023 01:28 PM
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"
Mar 27 2023 11:50 AM - edited Mar 27 2023 11:52 AM
@Hans Vogelaar just had to change the periods to commas to make 12 the dividing number and that worked perfectly, thank you!
Mar 27 2023 01:28 PM
Glad to see you were able to correct my stupid mistake! I have changed the periods to commas in my previous reply.