Alternatively, use the function to compute the difference between any two dates.

Thecell referenceto this location is entered into the formula.

One use for concatenation is to join number data and text data together when used in a single formula.

Screenshot of Excel showing age calculation

Lifewire / Theresa Chiechi

Worksheets recalculate each time they are opened.

The person’s current age increases when the worksheet is opened unless automatic recalculation is turned off.

Enter the formula into cell E3:

PressENTER.

Illustration of an Excel spreadsheet on a computer calculating age in a room with birthday cards and presents

Lifewire / Theresa Chiechi

Your current age appears in cell E3 of the worksheet.

Screenshot of Excel showing the entire age formula

Screenshot of Excel showing DATEDIF function being entered