Calculate Sports Division based on DOB

I have the following excel formula that works fine however I am trying to get to work in a SharePoint list: =IF(ISBLANK(B1),"",MAX(IF(MOD(IF(MONTH(B1)>8,0,1)+(YEAR(NOW())-IF(MONTH(NOW())<9,2,1)-Y...

microsoft lists

SharePoint Online

luis-ribeiro
Oct 16, 2023
Hi jkfromk

you can create a calculated column to calculate the age in years of the person in that specific date. using a formula like =DATEDIF(Birthday,DATE(YEAR(TODAY()),9,1),"Y") > You may need to adjust the month/day order depending on your regional settings.
And then create a new one where you add your conditions to categorize depending on the age using If conditions =IF([AGE-Y]<6,"U6",IF([AGE-Y]<8,"U8","O8")). You need to upate the formula and add the remaining conditions to all scenarios.
In the view will present the data:
Regards

luis-ribeiro

Brass Contributor

Oct 16, 2023

Hi jkfromk

you can create a calculated column to calculate the age in years of the person in that specific date. using a formula like =DATEDIF(Birthday,DATE(YEAR(TODAY()),9,1),"Y") > You may need to adjust the month/day order depending on your regional settings.

And then create a new one where you add your conditions to categorize depending on the age using If conditions =IF([AGE-Y]<6,"U6",IF([AGE-Y]<8,"U8","O8")). You need to upate the formula and add the remaining conditions to all scenarios.

In the view will present the data:

Regards

jkfromk

Copper Contributor

Oct 17, 2023

luis-ribeiro thank you! That worked. I ended up using this:

=IF([AGE 9/1]<6,"6U",IF([AGE 9/1]<8,"8U",IF([AGE 9/1]<10,"10U",IF([AGE 9/1]<12,"12U",IF([AGE 9/1]<14,"14U",IF([AGE 9/1]<16,"16U"))))))

Forum Discussion

Calculate Sports Division based on DOB

Resources