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.

Formulas and Functions

SergeiBaklan
Oct 03, 2018
Hi Richard,

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

MVP

Oct 03, 2018

Hi Richard,

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

Copper Contributor

Aug 29, 2021

Hi Sergei
My Excel doesn't have the datedif function on fx.

SergeiBaklan
MVP
Aug 29, 2021
JMennegke

Function is not mentioned in fx list and if you type it in the cell you see no prompt till first bracket. After that also not very informative, but at least something

Resources