Forum Discussion
Calculate school cohort
Lucy_Walker Here are 2 versions that will work:
=YEAR(C2)+4+(MONTH(C2)>8)=YEAR(C2)+4+(C2>DATE(YEAR(C2),8,31))The 1st is slightly more simple and adds 4 to the DOB year and then will add 1 if the month of the DOB is > 8 (after August) and adds 0 if not
The 2nd starts the same but then compares the DOB to a specific DATE made by the YEAR from the DOB and then month 8 and day 31. This second version would be needed if the break point was in the middle of the month.
Hope that help solve your problem and maybe gives you a little insight into a couple excel formulas.
Lucy_Walker Here are 2 versions that will work:
=YEAR(C2)+4+(MONTH(C2)>8)=YEAR(C2)+4+(C2>DATE(YEAR(C2),8,31))The 1st is slightly more simple and adds 4 to the DOB year and then will add 1 if the month of the DOB is > 8 (after August) and adds 0 if not
The 2nd starts the same but then compares the DOB to a specific DATE made by the YEAR from the DOB and then month 8 and day 31. This second version would be needed if the break point was in the middle of the month.
Hope that help solve your problem and maybe gives you a little insight into a couple excel formulas.
- mtarler
Thank you for firstly being so speedy and secondly for that wonderful formula which is now residing in my spreadsheet!! Allowing me to remove 4 columns and a huge headache!!
Have a great day 🙂
Lucyx
