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.

Find more posts tagged with

Formulas

Accepted answers

All comments

Melissa Yamada

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.

Screenshot 2025-01-26 at 11.42.17 PM.png

With this being said, try using long dates instead of the mm/dd/yy format.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.