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.

Silver Contributor

Oct 03, 2018

Hi Richard,

You can use the https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c function as follows:

=DATEDIF(A1,TODAY(),"Y")

Where cell A1 is the birthdate.

Hope that helps

Copper Contributor

Jul 22, 2021

This format did not work for me. Do you know why that would be?

Thanks