Calculate age based on birthdate

Hi there,

I use this formula to calculate age based on “birthday” date column (showing years) :

IF(MONTH(TODAY())>MONTH({Birthday});YEAR(TODAY())-YEAR({Birthday});IF(MONTH(TODAY())=MONTH({Birthday});IF(DAY(TODAY())>=DAY({Birthday});YEAR(TODAY())-YEAR({Birthday});YEAR(TODAY())-YEAR({Birthday})-1);YEAR(TODAY())-YEAR({Birthday})-1))

You could even chose to show “Happy Birthday !” on the exact day with this second formula, even though I find it more convenient to use the first formula and set up an automation to get notified on someone’s birthday, since it allows your “Age” column to be populated only by numbers, for instance if you want to calculate the average age in a team :

IF(MONTH(TODAY())>MONTH({Birthday});YEAR(TODAY())-YEAR({Birthday});IF(MONTH(TODAY())=MONTH({Birthday});IF(DAY(TODAY())>DAY({Birthday});YEAR(TODAY())-YEAR({Birthday});IF(DAY(TODAY())=DAY({Birthday});“Happy Birthday !”;YEAR(TODAY())-YEAR({Birthday})-1);YEAR(TODAY())-YEAR({Birthday});YEAR(TODAY())-YEAR({Birthday})-1);YEAR(TODAY())-YEAR({Birthday})-1))

I hope it can help anyone !

2 Likes

Thank you so much for this. Super helpful and just what i needed :slight_smile:

1 Like

Glad it could help you :slight_smile:

Thank you this was exactly what I was looking for!

1 Like

Hi and how to automate using a function field? I think this is not possible to get a notification using a function ?

Hi,

To get notifications, you should use the Automation feature, and set up something like “when this column reaches this value, then notify this person”
But I don’t know if this first column can be a formula one…

1 Like