# Calculating Ship Date

#### tsojda

##### New Member
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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### rallcorn

##### Well-known Member
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.)

Last edited:

#### tsojda

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

Good deal!!

Replies
1
Views
124
Replies
6
Views
237
Replies
2
Views
211
Replies
4
Views
266
Replies
4
Views
845

1,196,007
Messages
6,012,829
Members
441,732
Latest member
Ayon

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back