Google Sheets - Calculate Age in Days, Months, or Years

Learn how to use the DATEDIF function to calculate age if you have a start and end date. The output can be days, months, years, or a combination.

Learn more from Prolific Oaktree:

#googlesheets #spreadsheets #prolificoaktree

[thegoober]

Thank you so incredibly much, I spent an hour trying to figure out how to do this and you've saved me many more!

[khan-hgem]

Thanks alot, , You cant imagine how much of a big problem this solved for me, , Thanks

[ValmisFilm]

Thanks! But if I want to take into consideration the birth time? The clock? Like if a child was bord on 20.12.2022 at 14:50 then on 28.12.2022 at 14:00 it would not say 8 days, but 7, because the time has not arrived jet.

[JoshuaPaulKing]

Thanks so much! This was very helpful!!!!

[wendymccombie]

That was amazingly helpful, thankyou very much

[WhiteCleats]

Thanks for taking the time to make this -- it was very helpful!

I'm using these formulas for financial purposes -- calculating average age of accounts. Example: I have 10 accounts of varying ages. I've used your formula to express the age of those 10 accounts in months and then summed. Then divided by the number of accounts to get the average. What I can't figure out is what's next. How do I divide the average by 12 and then express it in plain English (example: 3 years, 6 months, 12 days)??

[Yutani_Crayven]

This only works in one direction (i.e. the first parameter has to be greater than the second parameter) and can't output the time part of a date-time field, only year, month and day. Hour and minute increments are not supported.

[dgajsek]

How would you calculate the date difference between today and the start_day? So I want it to have today as a dynamic number.

=DATEDIF(17/3/2017, TODAY(), "D") doesn't seam to work

[danyvaldi]

Hello friend, thanks for your video, but I have a problem, when I do the operation, =DATEDIF(K3, L3, "M") to know the difference of both dates in date only format, the "K3" stops being in color when I put the comma, and that means that the function is no longer usable, I tried separating the comma and it returned to color, but it gave an error, so I wanted to know what was happening, and how I can solve it, thanks

[gwencastro]

hi, how do you get the age if you only have the month and year of birth?