Help

Formula to calculate age on next birthday

Topic Labels: Dates & Timezones Formulas
211 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Homestead_Band
4 - Data Explorer
4 - Data Explorer

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
 
 
1 Reply 1

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

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