Date Formula Question

Eddie_T313 ✭✭
edited 06/15/22 in Formulas and Functions

I built a sheet that includes a column for D.O.B., and another for "Age at Admission," which contains a formula. I'd also like to have a column for "Current Age" that would work through D.O.B. Not sure how to set it up. Don't think it should be too difficult, though. Any help appreciated.


  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭


    The basic formula is something like:

    =ROUNDDOWN((TODAY() - [D.O.B.]@row) / 365.25, 0)

    This finds the number of days between today and the date of birth, and then divides by 365 and one-quarter days. (We include the .25 days to account for one leap day every 4 years.) The ROUNDDOWN function will round the number down to the nearest whole number, so if the result is 48.762 years, it will list the age as 48. You could replace the "0" at the end of the formula with 1, and that would round the age down to year and tenth of a year, so the result would be 48.7 years.

    If you want a more precise age, that's a bit more math!


    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!