I have created a formula using the workday function to look at a date in a3, due date is same day so I put 0, exclude holidays listed in another tab and return result. This formula works great if the due date is 1 or more days after the date in cell a3; however, when it is the same day, it returns the value regardless if it is a weekend or not.
The formula I am using is: =WORKDAY(A3,0,'Stat Holidays'!A2:A31) Where 'Stat Holidays' tab has a list of dates to exclude.

When a3 has a value of October 14th for instance, and the formula is =WORKDAY(A3,1,'Stat Holidays'!A2:A31), it returns the date Tue, October 15th, 2013, which is correct. Same if the value in cell a3 is October 11th, it returns October 15th as October 14th is a holiday. However.... if the formula is =WORKDAY(A3,0,'Stat Holidays'!A2:A31), it returns the same day October 14th, which is incorrect as this is on my stat holiday tab. If the date is October 12th (Sat), it also returns that same value. How can I fix this so that when the due date is the same date, it excludes the holidays and weekends.

Thanks!