Forum Discussion

Copper Contributor

Oct 03, 2018

Solved

Age calculation

I have a list of dates of birth from a membership spreadsheet. Is there a formula to give me ages of members against current date? Thanks in advance.

excel

Formulas and Functions

SergeiBaklan
Oct 03, 2018
Hi Richard,

Please check this https://exceljet.net/formula/get-age-from-birthday

beck6202

Copper Contributor

May 25, 2025

I have the same issue. I tried your formula and it worked great unless the DOB cell is blank. Then is fills the AGE cell with 125 based on the year 1900 I'm assuming. I need a formula that will leave the DOB cell blank if there isn't a DOB. I hope you can help!!!