Forum Academy Marketplace Showcase Pricing Features

Calculate age by birthdays date

How can I calculate user age by his birthday date?

Stay safe.

I’m sorry but none of the solutions worked for me. It seems they don’t take into account the leap years.

To me the solution was to emulate what you do in real life:

  • you look at the year of birth and make the difference with the current year
  • then you check whether the current day of the year is higher than the birth day of the year, and decide to subtract 1 or not

Here is the formula (i’m using a date / time picker):


Hope it helps someone! :slight_smile: