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

Dispatch Day	Leadtime	Proposed Delivery Day
Thursday	7	Thusday
Wednesday	4	Sunday
Friday	8	Saturday

<tbody>
</tbody>

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.