I want to do a roster that looks at the date in a month, and will only deduct the average production quantity if it is a weekday.

Here is my formula
=IF(C1=OR(WEEKDAY(6),WEEKDAY(7)),B14,(B14-$N$26))

C1 contains the date 1/1/11
C2 contains the day (Mon, Tue) derived from C1
B14 contains the estimated production qty for the month
N26 contains the average daily production qty

It won't detect sat/Sun and deducts when it should skip.

Thanks in advance for your help.

Skepticol