Want to know how old someone is, given their date of birth in a cell? You can use Excel's date functions to do just that.
In this video, learn how to use TODAY, DATEDIF, EDATE functions to calculate age from a date in Excel.
Learn more here - [ Ссылка ]
Sample File 📗👉
==============
Download practice workbook here - [ Ссылка ]
It has a special surprise for you.
More on Excel Date & Time calculations ⏱
===================================
Watch these videos to learn more about Excel date functionality.
3 Must have date formulas for finance people - [ Ссылка ]
Highlight date changes in your data with conditional formatting - [ Ссылка ]
Video topics:
==========
0:00 - Calculating the age in Excel
1:20 - Using the hidden DATEDIF formula
2:12 - Age as of a specific date
2:50 - Time to reach a age milestone (60 years)
3:58 - Calculating Employee's 5th anniversary with formulas
~
Have a beautiful day 🌻🌞😀
#Excel #Formulas
Ещё видео!