All2Cheesy
Board Regular
- Joined
- Mar 4, 2015
- Messages
- 127
Hi All,
Is it possible to set two sets of holiday ranges when writing a network days function?
Below is my current formula:
W2 and X2 refer to cell ranges.
Assistance would be greatly appreciated. Thank you.
Is it possible to set two sets of holiday ranges when writing a network days function?
Below is my current formula:
Code:
=IFERROR(NETWORKDAYS(C2,M2,LARGE((W2,X2),ROW(INDIRECT("1:"&ROWS(W2)+ROWS(X2)))))-1,"")
W2 and X2 refer to cell ranges.
Assistance would be greatly appreciated. Thank you.