Combining If and Workday function

[Jammydodger182]

Hi there

I’m trying to make a spreadsheet for work which will allow me to track daily assessments.
Basically, we either get two types of assessments to do - S17 and S47

mom trying to figure out how I create a formula that generates deadline dates for each assessment from the date it was received. The formula I’m using doesn’t exclude weekends and I can understand why not...

Timeframe for each assessment:

S17 - 5 working days to visit - 15 working days to complete the assessment
S47 - 1 working day to visit - 5 working days to complete the assessment

The formula so far for visits is...
=WORKDAY(A2+IF(D2=“S17”,5,IF(D2=“S47”,1,))-0,0)

this formula does not take into account weekend when I extend the deadline timescales from 5 to 45 for example.

 

[Dave Patton]

2 alternatives. I am not sure "15 days to complete".

Date and Time 2021.xlsm
	A	B	C	D	E	F
1					Visit	Complete
2	Fri 08-Jan-21			S47	Mon 11-Jan-21	Fri 15-Jan-21
3	Fri 08-Jan-21			S47	Mon 11-Jan-21	Fri 15-Jan-21
1b

Cell Formulas
Range	Formula
E2	E2	=WORKDAY(A2,IF(D2="S17",5,IF(D2="S47",1,0)))
F2	F2	=WORKDAY(A2,IF(D2="S17",15,IF(D2="S47",5,0)))
E3	E3	=WORKDAY(A3,1+(D3="S17")*4,0)
F3	F3	=WORKDAY(A3,5+(D3="S17")*10,0)