Moving Friday Commitment to Monday

[SPenney]

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

[tridom]

=IF(E9<>"",IF(TEXT(A9,"DDD")="FRI",A9+3,A9+1)) in B9 should do it.

[SPenney]

Excellent! That worked. Thanks much.

[daddylonglegs]

You can also use WORKDAY function to add a specified number of days to a date, this version in B2 will add 1 workday if there's an entry in E2, otherwise none

=WORKDAY(A2,(E2<>"")+0)

[SPenney]

Good call. I'll tinker with that too.