Nested IF statement with Networkdays.Intl calculation

[Galena1]

I have a simple 3 condition nested IF statement as follows: =IF(D4="High",E4+1,IF(D4="Med",E4+3,IF(D4="Low",E4+5," "))) where D4 contains a date. How do I get it to return only non-holiday weekday dates? I could create a tab in the workbook containing a list of my country's 12 holidays.

Any help would be greatly appreciated!

 

[James006]

Hi,
Have you tried :

=WORKDAY(E4,1)

 

[Galena1]

Hi,
Have you tried :

=WORKDAY(E4,1)

 

[Galena1]

Hi James. Thanks for the reply. What I was looking for was combining my nested 3 condition IF statement with either WORKDAYS or NETWORKDAYS function and to take into account a separate Holidays list. Kinda like:

=IF(D4="High",E4+1,IF(D4="Med",E4+3,IF(D4="Low",E4+5, Networkdays(E4:f4,Holidays!A1:A12))

In other words, the formula in F4 has to exclude Weekend days as well as well as any Holidays as defined in the tab named 'Holidays'. I was using the expression "E4+1", "E4+3", and "E4+5" to calculate a future date in F4, based on the text in D4 (low, med, high)

 

[awoohaw]

Try this:
Holiday is in G3, assuming Saturday and Sunday weekend.

mr excel questions 21.xlsm
	A	B	C	D	E	F	G
2							Holidays
3	Level	Date	NewDate				2023-03-30
4	High	Wed 2023-03-29	Fri 2023-03-31
5	Med	Wed 2023-03-29	Tue 2023-04-04
6	Low	Wed 2023-03-29	Thu 2023-04-06
Galena1

Cell Formulas
Range	Formula
C4:C6	C4	=WORKDAY.INTL(B4,IF(A4="High",1,IF(A4="Med",3,5)),1,$G$3)