Selected Answer
I'm not sure how you want to use the IF statement, or exactly how you want to use the networkdays function since you have different holidays listed for each row, but here is a sample networkdays function that will get you the number of days between the signup date and completion date, assuming saturday and sunday are the weekend and the holiday is in the same row in the holiday column.
=NETWORKDAYS.INTL(C2,G2,1,H2)
If this doesn't help, please edit your original question to include more detail.
Update:
If you are looking to get one of those three values depending on what is in the Current status field, I suggest you do it this way:
- Put the formulas to get the days for each potential status in their own column.
- Use 1 formula with nested IF statements to figure out which value to use.
- Hide the columns with all the days listed by selecting them and changing the color of the text for them to white.
For row 2 do this:
Column I:
=NETWORKDAYS.INTL(C2,G2,1,$H$2:$H$18)
Column J:
=NETWORKDAYS.INTL(D2,TODAY(),1,$H$2:$H$18)
Column K:
=NETWORKDAYS.INTL(C2,D2,1,$H$2:$H$18)
Wherever you want the correct Day amount to appear for row 2, put this formula:
=IF(F2="Completed",I2,IF(F2="In Process",J2,IF(F2="Pending",K2)))
Now, just copy the formulas down for the entire list.
You could put all of this into one formula but it will be MUCH more confusing to maintain and change. My method makes everything a lot easier to manage.
Try this out. I assumed that all of the days in the H column were the holidays that needed to be used for the formulas.