# How can I calculate age in MS Excel if the year of birth is provided in one column?

No DOB, only year of birth data is there in one column, need to calculate corresponding age in the other column based on today’s year/date.

• Do you mean, you can calculate age only approximately (~1 year)? Commented Sep 23, 2016 at 14:48
• Can you show the formula you've tried please
– Dave
Commented Sep 23, 2016 at 14:57

Enter this in cell `B2` and drag this down to other cells in column `B`:

``````=IF(A1="", "", YEAR(NOW())-A1)
``````

Assumptions:

• The year of birth is in column A.
• Calculating the approximate age based only on the year.
• You want the approximate age displayed in column B.
• You want to leave the result blank if the corresponding year of birth is not entered.

Excel's formula for current year

``````=YEAR(TODAY())
``````

To get your desired result, simply deduct the year of the DOB from the above formula to get the age of each individual.

• How to do that deduction. Also, how to apply that logic for entire column (means multiple rows of data)? Sorry, I am a newbie to excel formulas. Commented Sep 23, 2016 at 15:23
• Also I want the formula to leave the cell blank if year value is absent. Commented Sep 23, 2016 at 15:35