Далее

Calculate Age in Excel from Date of Birth | Simple Formula #Shorts

3 Просмотры· 27/02/24
Administrator
Administrator
2 Подписчики
2

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

Подробнее

 0 Комментарии sort   Сортировать по


Далее