If word equal add 10 working days or 3 working days

[KrisCz]

Hi Guys,
I did my best but couldn't sort it out, I ried if, and, move yhings around but no luck
I need formula in J3 which will add 3 or 10 working days depending on word specified in cell G3, if word is "Live" or "Start Date" then I'd like to add 3 days to date specified in F3 if any other word in G3 then 10 days.
In addition if it is possible I'd like to highlight cell in red 2 days before due day as well.

Tracker Insurance(AutoRecovered).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
2	Applicant(s) Name(s)	Joint?	Policy No	Provider	Policy Type	Application Date	Status	Start Date	Months In Force	Letter Due Date	Letter Yes/No	Total Commision
3						29/11/2021	Live	10/10/2010	133	13/12/2021
4						20/10/2020				03/11/2020
5
6
7
Sheet1

Cell Formulas
Range	Formula
I3:I7	I3	=IF(H3="","",(YEAR(G$1)-YEAR(H3))*12+MONTH(G$1)-MONTH(H3))
J3:J7	J3	=IF(F3="","",(WORKDAY(F3,10)))

Cells with Data Validation
Cell	Allow	Criteria
K3:L7	List	Yes, No
B3:B7	List	Yes, No
D3:D1048576	List	Aegon, AIG, Aviva, British Friendly, Canada Life, Cirencester Friendly, Guardian, Legal & General, LV=, Royal London, Scottish Widows, Vitality Life, Zurich, Paymentshield, The Exeter, Shepherds Friendly
E3:E1048576	List	Life, CIC, Life+CIC, Income, Home Insurance, PMI, ASU
G3:G7	List	Live, Referred, Postponed, Rated, Declined,No Start Date, Start Date

 

[Fluff]

How about

=IF(F3="","",(WORKDAY(F3,IF(OR(G3={"Live","Start Date"}),3,10))))

 

[KrisCz]

I tried something like that
=IF(G3="Live, Start Date", (F3="","",(WORKDAY(F3,3))), (F3="","",(WORKDAY(F3,10)))
but I'm guess I am not even close to solution.

 

[KrisCz]

=IF(F3="","",(WORKDAY(F3,IF(OR(G3={"Live","Start Date"}),3,10))))

Thank You Fluff it works perfectly, quick as always

 

[Fluff]

You're welcome & thanks for the feedback.

 

[KrisCz]

WORKDAY(F3,IF(OR(G3={"Live","Start Date"}),3,10)))

It is working but I am intrigued how does it working?
If you find a moment would you be able to explain it?
How does excel knows when to add 10 and when to add 3 days?
How words relates to days? (3,10)

 

[Fluff]

It's saying that if G3 is Live or Start date then use 3 else use 10