Today formula

CAKutsh

I am trying to determine by looking at today's date and subtracting birthdate, how to get a person's age. I am new to this so any help is appreciated.

Jeff M.

Hi,

Copy and past the formula below into your AGE column. Make sure to edit the formula name if your other column is not named "Date of Birth".

=(YEAR(TODAY()) - YEAR([Date of Birth]@row) - IF(AND(MONTH(TODAY()) <= MONTH([Date of Birth]@row), DAY(TODAY()) <= DAY([Date of Birth]@row)), 1))