Formula to calculate person’s age as of today

Ask the Community Formulas
#1

Hello Stackby community,

I am running an e-commerce store and using Stackby for maintaining the customer information and so needed their respective ages in a separate column.
I need to show the person’s age as of today in one specific column using a formula. Can anyone tell me the exact formula for this?

#2

Hi Yetirej,

I suppose you have Birthday column in your table, that has the birthdates for all your customers.

You can use the formula below:

DATETIME_DIFF(TODAY(), {Birthday}, ‘years’)

You can check out this DATE Difference article as well.