How to infer age from employee's date of birth

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

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

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