Need Help with a Delivery Schedule Formula

So I was tasked with a very peculiar challenge...calculating delivery dates using an Excel formula.

I'm new to Excel especially when it comes to formulas and I haven't grasped most of the basic functions yet

Here is my scenario:

I have a requirement that if I receive an order today it will be delivered the next business day. So when I receive an order I want to record the correct delivery date based on the day of the week the order was placed

If the day is Monday thru Thursday then add 1 day

If the day is Friday then it will deliver the following Monday

If the day is Saturday or Sunday then it will deliver on Tuesday (since it is treated as if it was placed on Monday)

Attached is the workbook I'm playing around with, I've tried working with the WORKDAY() function but I believe this goes more complex into conditionals

Welcome to the forum.

i am not at all clear why you think this is a "peculiar" request - we get people asking about this all the time!

Seems I need to lurk around some more! haha.

I had issues managing attachments but I've attached my spreadsheet to my OP

Try this for size:

=WORKDAY.INTL(A3,1)+IF(WEEKDAY(A3,2)>5,1,0)

Excel 2016 (Windows) 32 bit

	A	B	C	D	E
1				Expected Value
2	Order Date	Week Day		Delivery Date	Your Value
3	18/05/2020	Monday		19/05/2020	19/05/2020
4	22/05/2020	Friday		25/05/2020	25/05/2020
5	23/05/2020	Saturday		26/05/2020	26/05/2020
6	24/05/2020	Sunday		26/05/2020	26/05/2020
7	25/05/2020	Monday		26/05/2020	26/05/2020

Sheet: Sheet1

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

First shot:

Please Login or Register  to view this content.

Thanks for the rep. Glad you liked the solution.