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!
Any help would be greatly appreciated!