Function Problems

Calculate Age in Excel for Today or a Specific Date

Khadija KhanKhadija Khan Nov 13, 2026 869 views

Question details

Calculate a person's age from a date of birth using either today's date or a specific reference date in Excel.

Product
Microsoft Excel 2016 and later
Device & OS
not provided
Scenario
A date of birth is stored in A1, and the user wants an age in whole years as of today or a date entered in A2.
Observed behavior
The result should display as a whole number. Dividing elapsed days by 365 provides an approximation, while DATEDIF can return completed years.
Before you start

Enter a valid Excel birth date in A1. For a specific reference date, enter it in A2 and confirm that it is not earlier than the birth date.

Solution 1Recommended

Calculate an approximate age using INT and elapsed days

Use these simple formulas when an approximate age is sufficient. They divide elapsed days by 365 and round down to a whole number.

1
Enter the birth date

Select cell A1 and enter the person's date of birth as a date Excel recognizes, such as March 15, 1990.

2
Calculate age as of today

Select an empty result cell, such as B1, enter =INT((TODAY()-A1)/365), and press Enter.

3
Calculate age on a specific date

Enter the reference date in A2. In another empty cell, such as B2, enter =INT((A2-A1)/365) and press Enter.

4
Display the result as a whole number

Select the result cells, open Home > Number Format, and choose Number. Use Decrease Decimal until no decimal places are displayed.

These formulas provide an approximation: Dividing by 365 does not account for leap years and can overstate age near a birthday. Use DATEDIF when you need age in completed years.
Calculate age in WPS Spreadsheet

Calculate Age from Birth Dates in WPS Spreadsheet

Use WPS Spreadsheet to calculate approximate ages with INT or completed years with DATEDIF. You can use today's date or a fixed reference date and save the results in an Excel-compatible workbook.

  1. 1. Open your workbook: Open WPS Spreadsheet and create a blank workbook, or use Menu > Open to open an existing Excel workbook.
  2. 2. Enter the dates: Select A1 and enter the date of birth. If you need age on a fixed date, enter that reference date in A2.
  3. 3. Enter an age formula: Select B1 and enter =DATEDIF(A1,TODAY(),"Y") for completed years today, or =DATEDIF(A1,A2,"Y") for completed years on the reference date. For an approximation, use =INT((TODAY()-A1)/365).
  4. 4. Format and save the result: Select the result cell and choose Home > Number Format > Number, then reduce decimal places to zero. Use Menu > Save As and choose .xlsx to keep the workbook in an Excel-compatible format.
Calculate age as of today or any valid reference date.Use familiar spreadsheet functions, including TODAY, INT, and DATEDIF.Open and save Microsoft Excel .xlsx and .xls files.Display age results as whole numbers with spreadsheet formatting controls.
QA img-9

Frequently Asked Questions

Why can dividing by 365 give the wrong age?

The formula =INT((TODAY()-A1)/365) treats every year as 365 days. Accumulated leap days can make the result increase before the actual birthday. For completed years, enter =DATEDIF(A1,TODAY(),"Y") in the result cell.

How do I calculate age on a past or future date?

Enter the birth date in A1 and the reference date in A2. Use =DATEDIF(A1,A2,"Y") for completed years, or =INT((A2-A1)/365) for an approximation. The reference date must not be earlier than the birth date when using DATEDIF.

Why does my age result look like a date instead of a number?

The result cell is probably formatted as a date. Select it and choose Home > Number Format > General or Number. For Number format, reduce the decimal places to zero.

Will an age formula using TODAY update automatically?

TODAY updates when Excel recalculates the workbook. In Excel, choose Formulas > Calculation Options > Automatic to enable automatic recalculation. Use a fixed reference date in A2 instead if the age should remain tied to a particular date.