I did some research how to make a list of the next birthdays, I post it here for future reference (for myself or others).
Step 1:
Have a date field: “Birthdate”
Step 2:
Calculate “Current age” from the “Birthdate”
Floor(Datediff( Now(),{Birth date})/(1461/4))
P.S. 1461/4 Is number of days in 4 years, so including the leap year. This is not 100% accurate though, so there might be a better equation for this.
Step 3:
Calculate “Next birthday” by adding the age to the “Birth date”, but correct for if you already had the birthday this year or not.
IF(Date_add({Birth date}, INTERVAL {Current age} year)<Now(), Date_add({Birth date}, INTERVAL {Current age}+1 year), Date_add({Birth date}, INTERVAL {Current age} year))
Step 4
If you want to create a list with upcoming birthdays, you will also need to calculate in how many days the birthday will be from Now(): “Days until next birthday”
DATEDIFF({Next birthday},Now())
You can use this in the “Sort by” of your table.