Calculating Age from DOB Column

Nancy Mayberry

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.

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.