Calculating Age from DOB Column
Group,
I’m calculating people's age on their birthday this year using this formula:
=YEAR(TODAY()) - YEAR(DOB@row)
It works for most cases, but for some reason, it returns a negative number for people born in the 1940s. See the screenshot for details. Any idea what I'm doing wrong?
As always, thank you.
Answers
-
Hello @Nancy Mayberry
I was able to replicate the issue you encounter. It seems like it might be related to how the year is being displayed. When I changed the date format to a long date, it showed dates from < 1946 as 20xx instead of 19xx, which is causing the negative result.
With this being said, try using long dates instead of the mm/dd/yy format.
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!