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

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

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

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

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

You are the man, Saved my time.

My hero!! Thank you so much!

Very helpful thank you! But what if you needed to calculate year and month from a specific date (not today)?

Thank you so much for this.❤

thank you....

Thanks!

but what if the other way around. the age is given and how to determine the birthdate

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.

beautifully done! :)

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

The best..

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

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

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…

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.

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!

Tankuu

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

office 2019 does not come with datedif

how to calculate the birth year if age is known

How to calculate age in years and months for specific date