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 ...

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.