Add days of the week, no date involved

[Frosty516]

First post, long time student of the site. So thanks to all who have educated me over the years! If my question is in another thread, sincere apologies but I have not been able to locate it.

I am working on a forecasting tool that will utilize work in progress (WIP) and work completed (Throughput) based on hours of the day. At times, the WIP will carry into the next day. I need my "IF" formula to make that decision based on previous formulas and change the day of the week.
Example: A14 = Monday ....the rest of Row 14 will detail my WIP and Throughput. When the shift completes, formulas will carry over to Row 15. Based on the times, I need A15 to either remain as Monday or to add another day and report as "Tuesday".

I can utilize nested IF statements to make this happen but it gets a little confusing because it also needs to make a decision based on the time that the shift ends in row 14. Is there a way in Excel to look at cell A14 and add one day to elicit a "Tuesday" response?

Many thanks in advance.

 

[Dave Patton]

We can not see your spreadsheet and we would need more information to provide an answer.
A few ideas are shown below.
You can use the lookup formula that you prefer and put the table where you prefer.
I did not know the criteria that you mentioned; you can edit that part of the formula.
Column C is an example if you use actual dates.

Excel 2010
	B	C	D	E	F	G
12					Monday	Tuesday
13					Tuesday	Wednesday
14	Monday	Mon 25-Sep-17	Monday		Wednesday	Thursday
15	Tuesday	Tue 26-Sep-17	Monday		Thursday	Friday
16					Friday	Monday
17
1b

Cell Formulas
Range	Formula
B15	=VLOOKUP(B14,$F$12:$G$16,2,0)
C15	=WORKDAY(C14,1)
D15	=IF(M14>100,VLOOKUP(D14,$F$12:$G$16,2,0),D14)