I'm using =C45+(7-WEEKDAY(C45,15)+1) to display the date of the next Friday in a target cell when the source cell is C45. I need to adapt this so that the target cell, a) only displays dates that are Fridays and b) is always at least 4 days later than the source cell. So e.g. if source cell is 9 October 2023 (Monday) then target cell should display 13 October 2023. But if source cell is 10-16 October then the target cell should display 20 October.
Any advice appreciated, thank you.
Any advice appreciated, thank you.