Calculating Ship Date

[tsojda]

Hi,

I'm trying to figure out a formula that would compute a shipping day when given the event date. The supplies would need to arrive the previous business day. FedEx is our carrier and doesn't count Saturday or Sunday as a transit day. The ship out day also does not count towards the transit days.

For example, we have a event on a Monday. Supplies would need to arrive on Friday. The estimated transit time is 3 business days. We would have to ship-out the supplies on Tuesday so that it will be delivered on Friday (remember: the ship day doesn't count towards the transit day).

I would greatly appreciate the help.

Thanks,

Tim

 

[rallcorn]

Check out workday:

With Event Date in A2, B2 ship date formula =WORKDAY(A2,-3) (If you read-up on workday function, you'll see that you have the option to list holidays somewhere and also take those out of the mix.)

 

[tsojda]

Thank you very much. That worked perfectly. Implementing the holidays worked as well.

 

[rallcorn]

Good deal!!