non-working holidays

in Excel, I made ​​a table where the records of employees work.
In column A2: A31 are the dates in January, etc.
I wrote a function holidays and now
in cell D2 I need a formula that will in cell A2 recognized holiday, and if
the working day to enter No. 8
For example: if the date in cell A2 1.1.2011. (Saturday) in cell D2 should be 0, and if the date 6.1.2011. (Thursday).
should be No. 8.
Holidays on Saturdays and Sundays should be excluded.
Thank you for your help.