How to calculate Age in ranges (ex: <25, 25-35, 35-45, >45)

Hello Community.
I was looking to aggregate employees age into ranges such as:

< 25
type or paste code here

Since I wasn’t able to find one simple way I came up with a very ugly (but functional) one, if you know about any better way please let me know :slight_smile:

On the meantime, if you are also looking to aggregate ages by range, here is what I did, hope it helps someone to save some time

Days(Today(),{Birth Date})
),365)),0)) < 25, "< 25",

Days(Today(),{Birth Date})
),365)),0)) >= 50, "> 50",

Days(Today(),{Birth Date})
),365)),0)) >=25, (ROUND((DIVIDE((
Days(Today(),{Birth Date})
),365)),0))<=35), "25-35",


The column with the birth date of the employee is of course called {Birth Date} so, if you happen to have the same problem, just create the formula and replace that name with the name given to your column

1 Like