calculation incorrect

[cmccabe]

I am trying to calculate a integer number difference from two dates (TAT = Due-Date - Result_Date). The number is calculated and excludes weekends and holidays. The function below seems to calculate a number but doesn't exclude weekends or holidays.

For example, if Due_Date is 9/26/2014 and Result_Date is 9/30/2014, then TAT is calculated to be 5 (should be 2)

Since 9/26/2014 is a Friday only Friday and Monday are used in the calculation. Thanks.

Please Login or Register  to view this content.

[mrice]

Have you tried the NETWORKDAY function?

[cmccabe]

I want to use VB for this and refer to a table of holidays:

VB

Please Login or Register  to view this content.

Not sure if that will work. Thanks .

If there is a holiday date that matches [Due_Date] - [Result-Date] then it is excluded?

[shg]

=NETWORKDAYS(fromDate, toDate, tblHoliday)