If formula for week commencing date

Hi,

I have an IF formula “=IF(AND(AK$6>=$B7,AK$6<=$C7),"","")” which I need amending to be more flexible to allow for dates to occur within a range.

In my example in cell AK8 I need this to appear as an arrow as the row above. The reason for this is in row 6 these are week commencing dates and the date of the 14th is in the same week as week commencing 13th.

Can anyone help please?

I think I have managed to do =IF(AND(AK$6>=($B8-WEEKDAY($B8,2)+1),AK$6<=$C8),"","")

Just testing now