DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it.

It’s not as complicated as it sounds, and there’s a handy function in Excel that can give you an exact age to the day. Read on for tips on how to calculate age in Excel. Read more: How to add ...

If you want to calculate how much time is left until a certain expiry date, you can use the DATEDIF function. This function returns the difference between two dates in terms of days, months, or years.

How to Convert DOB to Age in MS Excel. Microsoft Excel provides a function that displays a person's age based on his date of birth. ... Excel-2010.com: Excel DATEDIF; Rebecca Johnson.