Date Formula Question
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.
Answers

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 onequarter 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!
Regards,
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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 123 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!