How to Calculate Age in Excel: 3 Easy Methods

Microsoft Excel offers several ways to calculate age from a birth date. Here are the three most reliable methods.

Method 1: DATEDIF Function. Use =DATEDIF(A1, TODAY(), "Y") to get complete years. Replace "Y" with "M" for months or "D" for days. This is the most accurate method for exact age.

Method 2: YEARFRAC Function. Use =INT(YEARFRAC(A1, TODAY())) for decimal-precise age. YEARFRAC accounts for leap years and varying month lengths.

Method 3: Simple Year Subtraction. Use =YEAR(TODAY())-YEAR(A1) for a quick estimate. This doesn't account for whether the birthday has passed in the current year.

For precise age calculations down to milliseconds, we recommend using our online age calculator at Age Right Now — it handles leap years, time zones, and sub-second precision automatically.