Change your CF to the following
It's A2 that matters
EDIT : your initial CF uses A8 but applies to the range starting in row 2, so at each row A8 increases as usual and when reaching row 27 the formula looks for the value in A33 which is empty and returns a 7 as weekday. The following rows do the same. The CF thus never kicks in