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. 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