Sorry, but it's not working. Still the same result, does not count the day off when holiday is on weekend.Ok, how aboutExcel Formula:=NETWORKDAYS(E6,F6,Sheet1!$A$2:$A$13)+NETWORKDAYS.INTL(E6,F6,"1111100")
But you saiddoes not count the day off when holiday is on weekend.
Which is exactly what the formula I suggested does.But if holiday is on weekend then it should be a free day and not be counted.
Thanks!If you simply want to count all days without holidays, then tryExcel Formula:=NETWORKDAYS.INTL(E6,F6,"0000000",Sheet1!$A$2:$A$13)