Age Calculator Tutorial In Microsoft Excel | Use DATEDIF Function with Date of Birth

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

[voiceofparadise]

THanks for the video. But i m facing difficulties when inserting formula as DATEDIF is not taking up. Can u pls help out here.

Its MS 365 enterprise

[johngreener]

Thanks for sharing! Can this formula be inserted in an excel form?