Hi All, I need a formula to work out 21 days from the Friday after a delivery has been made during a week, eg delivery date is Tuesday 27th October, and my payment date is 21 days from the Friday of the week of delivery ie 21 days from Friday 30th October (so Friday 20th November). Is this possible to do in excel?

Thanks in advance