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.

Tags:

Answers

  • Melissa Yamada
    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.

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!