Forum Discussion

jkfromk's avatar
jkfromk
Copper Contributor
Oct 16, 2023
Solved

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's avatar
    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

     

Shikatanori's avatar
Shikatanori
Copper Contributor
May 26, 2025

To calculate a sports division based on DOB, you usually need to reference the athlete’s age as of a specific cutoff date defined by the organization. For example, if someone is turning 18 before a certain date in the season, they might be placed in the U19 category. It varies between sports, but age brackets like U13, U15, U17, etc., are quite common.

Resources