#### Da Food Guy

##### New Member
I am building a simple calculator for some of my corworkers, and I need some formula help.

Basically I am creating a calculator that you enter a ship date, then subtract days for lead time. I have the simple part down, but I need it to report on the workday BEFORE the deadline to ship (i.e if it falls on a sunday, then it needs to ship on the previous friday).

Both the ship date and the leadtime are fixed seperate cells that the user will change as needed for the customer.

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Welcome to MrExcel!

Assuming your calculated ship date is in cell A1,

=IF(WEEKDAY(A1,2)>5,A1+5-WEEKDAY(A1,2),A1)

Regards,

You could use the WORKDAY function available with Analysis ToolPak.

If your ship date is in A1 and lead time (in days) in B1

=WORKDAY(A1-B1+1,-1)

Thanks!

Sorry Mr. Davidson, I forgot to mention that I was using two fields (one for the ship date, the other for the lead time). Mr. Houdini's solution worked perfectly. Thanks to everyone!

Replies
7
Views
326
Replies
4
Views
431
Replies
7
Views
749
Replies
8
Views
157
Replies
5
Views
437

1,214,437
Messages
6,119,522
Members
448,903
Latest member
StephMJ

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