Birthday formula

[Homestead_Band]

I have a base with information about students in a music program, including their birthdates (MM/DD/YYYY). I have a formula that calculates their age as of today:

DATETIME_DIFF(TODAY(), {Birthdate}, 'years')

and a formula that calculates the number of days to their next birthday:

IF({Days from today} < 0, {Days from today} + 365, {Days from today})

I want to create a field that will tell me how old they will be on their next birthday. Is it as simple as adding 1 to the formula that calculates their age as of today?

Thanks-

Jen

[Sistema_Aotearo]

Yes, I believe you're right! Just adding 1 to your formula should do the trick!

DATETIME_DIFF(TODAY(), {Birthdate}, 'years') + 1