Calculate Age in Excel from Date of Birth | Simple Formula #Shorts
In this video, we calculate age in Excel from the date of birth with a simple formula.
The YEARFRAC and TRUNC function are used in this formula. The YEARFRAC function is the best method to calculate age from date of birth. There are many methods to remove the decimal part of the result. I like the TRUNC function for that task.
Grab a copy of 'Advanced Excel Formulas' and master Excel formulas today
https://amzn.to/3Rg87Go
Find more great free tutorials at;
https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
#Shorts #ExcelTutorials #ExcelFormulas
