I’m familiar with the NETWORKDAYS function in Excel and have been using it for years to calculate the time elapsed (in days) between two dates.

EX:
“=IF(NETWORKDAYS(A1,B1,Holidays!$A$1:$A$100)-1>=0,NETWORKDAYS(A1,B1,Holidays!$A$1:$A$100)-1,IF(ISBLANK(B1),NETWORKDAYS(A1,TODAY(),Holidays!$A$1:$A$100)))”

When I was asked to design a spreadsheet containing a calculation similar to the one above, but for calendar days, I figured it’d be easy enough, but I’m not so sure, now. The trick here is that we still need to omit our list of holidays from the calculation.

Is there another function (like NETWORKDAYS) for calendar days, or is it assumed that one should simply use “A1-B1?” If that’s the case, is there a way of excluding a list of dates from simple expressions (like “A1-B1”)?

Thanks so much for your help,

-J