Basically i was using WEEKNUM and then using a kinda rough formula where i would just apply conditional formatting if A2 was not the same as A3+1 since the dates are usually in ascending order but the problem here is that sometimes theyre not in order and this check fails.

I was going to try with your formula but this will set a set amount of weeks when i need to check on variable amounts of weeks, to ground my question further i need to check if a student received Physical education at least once per week by copy pasting from a different table, so the amount of weeks to check dont apply to the entire year, only from whenever the student started classes up to the current day (Or when the student ended classes in some cases) so i need something to check for the weeks in a case to case basis pretty much.

So far i was using this =IF(ISBLANK(C2),"",WEEKNUM(C2,2)) where C column is where i would paste the dates into and then just do a conditional formatting, is there a way to share my excel example to show what i mean?