Just the other day, I needed to calculate ages for several people based on their date of birth. Rather than doing this manually, I set up an Excel spreadsheet and made use of the DATEDIF function to do the work for me. Let me show you how!
In a hands-on demo, I’ll show you:
00:00 – Video intro
00:22 – How to set up the data in the correct format (dates and numbers)
00:58 – How the DATEDIF function works in Excel
01:40 – How to enter the DATEDIF formula to calculate age from date of birth
02:30 – How to apply the DATEDIF formula to multiple cells