Hi

I have just found the below formula that works!

=TRUNC(((AE9-C5)+6)/7)+(WEEKDAY(AE9)=WEEKDAY(C5))

Thank you for your help