How to infer age from employee's date of birth

Platform discussions
1

For example, I was born in 1989, how to directly display 32 years old

2

Hello, @chen1 - You can add a Formula column that calculates the age:

IF({DOB}<>"",ROUND(ABS(DIVIDE(DAYS(TODAY(),{DOB}),365)),0),"")

should work

1 Like
3

it works thank you !

在 2021年5月4日 10:03，Polished Geek more with monday.com | Certified Partner via monday Communitymonday@discoursemail.com 写道：

| Polished Geek: more with monday.com | Certified Partner PolishedGeek monday.com Partner
May 4 |

  • | - |

Hello, @chen1 - You can add a Formula column that calculates the age:

IF({DOB}<>"",ROUND(ABS(DIVIDE(DAYS(TODAY(),{DOB}),365)),0),"")

should work

4

Thanks for the post. I needed it too, but I needed age before birthday this year too. I modified your formula for my application. Posting this if someone else needs it. should be accurate to +/- 1 day.

IF({Birthday}<>"",TRUNC(ABS(DIVIDE(DAYS(TODAY(),{Birthday}),365.25)),0),"")
1 Like