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

Download the featured file here www.bluepecantraining.com/how...
In this video I demonstrate how to calculate age from date of birth or a specific date. I also demonstrate how to display age in years and months eg "45 Yrs 3 Mths"
The functions used in this video are TODAY(), YEARFRAC() and DATEDIF()
This video answers the following queries:
Calculate age in Excel from two dates
Excel formula to calculate age on a specific date
Calculate age in excel in years and months
How to calculate age in Excel from date of birth
Excel convert DOB to age
------------------------

[@callmatt64]

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

[@tjiss7094]

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

[@TroyJScott]

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

[@sudhirudayagiri2603]

You are the man, Saved my time.

[@missseonaidjervis6367]

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

[@rollindauazeua8548]

Thank you so much for this.❤

[@danavaughn6918]

My hero!! Thank you so much!

[@cristianomasciulli6472]

Thanks!

[@ArtisanNali]

beautifully done! :)

[@zarahmontiel]

thank you....

[@mamnars8318]

The best..

[@bungy1962]

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.

[@ChesterTugwell]

Great to hear!

[@jonesfamilyusa]

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

[@srivlog123]

Tankuu

[@kanewilton9708]

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!

[@kanewilton9708]

FOUND IT!! Needed a space at the end of " Yrs " Thanks, y'all!

[@rpcantiga]

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

[@sachingrpl]

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…

[@Monahulosousa]

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.

[@sarahh.6923]

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

[@greglapura2495]

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

[@ubaidillahmuhammad20]

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

[@ChesterTugwell]

Apologies Ubaidillah - the file is now available.

[@irshadbaruah7961]

how to calculate the birth year if age is known

[@mr.mandarmestry5156]

How to calculate age in years and months for specific date

[@patrickvanloggerenberg]

office 2019 does not come with datedif