Calculate age from a birthday date

johann ✭✭
edited 08/23/23 in Formulas and Functions

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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!