Calculate age from a birthday date

Options
 johann
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

Johann

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!