How To Forecast Delivery Day Based On Dispatch Day & Leadtime?

[xlmaniac]

Dear All,
I do have a small data set across A1:C4 as follows:-

[TABLE="width: 300"]
<tbody>[TR]
[TD]Dispatch Day[/TD]
[TD]Leadtime[/TD]
[TD]Proposed Delivery Day[/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD]7[/TD]
[TD]Thusday[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD]4[/TD]
[TD]Sunday[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD]8[/TD]
[TD]Saturday
[/TD]
[/TR]
</tbody>[/TABLE]
I would like to forecast the delivery day based on the Dispatch Day & the corresponding leadtime.
For example, if the dispatch day is Thursday and the leadtime is 7 Days, then the forecasted delivery day will be Thursday.
If the dispatch day is Wednesday and the leadtime is 4 Days, then the forecasted delivery day will be Sunday.
Could somebody help me out with the solution pls?
Regards

 

[wideboydixon]

Given that 1st December 2017 was a Friday, you could do something like this:

Book1
	A	B	C
1	Dispatch Day	Leadtime	Proposed Delivery Day
2	Thursday	7	Thursday
3	Wednesday	4	Sunday
4	Friday	8	Saturday
Sheet1

Cell Formulas
Range	Formula
C2	=TEXT(DATE(2017,12,MATCH($A2,{"Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday"},0))+$B2,"dddd")

WBD

 

[FormR]

Hi, another option, similar principle.

=TEXT(DATE(0,1,B2+SEARCH(LEFT(A2,2),"SASUMOTUWETHFR")/2),"dddd")

 

[xlmaniac]

Hi, another option, similar principle.

=TEXT(DATE(0,1,B2+SEARCH(LEFT(A2,2),"SASUMOTUWETHFR")/2),"dddd")

Thanks WBD & FORMR for the wonderful solution.
Really appreciate your support.