Moving Friday Commitment to Monday

Hi, all.

I have a delivery schedule that I'm working on measuring the Planned Arrival (column B) against the Actual Arrival (column A). These dates are generated by my internal program.

I have a business rule that allows one extra day in specific situations. The system doesn't capture that criteria, so I need to add a Modified Arrival Column into my report (column C) when the rule exists.

The trouble happens is when I need to shift a Friday delivery to Monday, since adding 1 puts the modified date on Saturday, which still will be off from what is intended.

I attached a file with sample data. If someone has a why of modifying my formula to adjust for the weekend, I'd love the feedback.

Thanks,

Stac