How to Calculate Age in Excel from Date of Birth or Specific Date | Age in Years and Months

Is there a way to have it update what cell the start date it in if I add a new row?

This video helped me today. Thank you for putting out there for us!

office 2019 does not come with datedif

Really useful. Thank you applied perfectly to a spreadsheet I’m currently working on 👏🏼

Exactly what I was looking for and clearly explained - thanks!!

thank you....

The best..

Very well presented and easy to follow, thanks!!!

beautifully done! :)

Thank you so much for this crash course.
I'm having an issue with the final formula:
My end value is represented at "21 Yrs6 Mths"
There is no space between "Yrs" & "6." any ideas?
I've placed an additional space in many of the spots of the equation with no luck, yet.

Thank you!

My hero!! Thank you so much!

Thank you so much. I was struggling how to figure it out and cleared it all up for me . :) The video is greatly appreciated.

Hi everyone, I am looking for a formula to subtract year from age excel. I have the number of years eg. 26 and I'd like to the DOB (01-jan-1995). Essentially I'd like to subtract 26 years from todays date. Greatly appreciated.

You are the man, Saved my time.

Hello sir….i want to calculate employee tenure. I know how to calculate when we have start & end date. But when END DATE is not available it should automatically calculate the tenure by taking current date. Pls help me…

How to calculate age in years and months for specific date

how to calculate the birth year if age is known

Pls help...i did this formula but result is name?

Chester. Great stuff, I've been (Trying to learn VBA) looking at your vids and the content is well explained and easy to follow. Many thanks.

Useful knowledge. but where is the file, sir ? (Download the featured file here : it's none)

Thanks!