Calculate age from a birthday date

johann

Hello, We receive the birthday date from a form and I want to put on cell the age automatically. How can we do to make a formula to put the age form a birthday date.

I think this works. =(TODAY()-(birthday))365

Thanks for your help

Johann

florian.zbinden7

Hi johann,

if you just add the "/" I think it works.

=(TODAY() - ([birth date]@row)) / 365

2023-08-23 10_37_31-birthday date calc - Smartsheet.com.png

is this what you are expecting ?

best regards

Florian

florian.zbinden7

Hi johann,

if you just add the "/" I think it works.

=(TODAY() - ([birth date]@row)) / 365

2023-08-23 10_37_31-birthday date calc - Smartsheet.com.png

is this what you are expecting ?

best regards

Florian

johann

yes, thank you very much

best regards