All,

I am trying to figure out number of WORKING days per each week (1-6) of each
month excluding holidays. I have set up a sheet as follows:

B1=1/1/2010
then I have weeks#1 through 6 as a label in cells A3 through A8
in cell B3 I have the following formula:

=MIN(31-DAY(B$1+31),$A3*7-WEEKDAY(B$1))+1-SUM(B$2:B2) and the same formula
is dragged to populate cells B4 through B8.

I also have a named range defined for FY10_Holidays

The above formula works, but does not excludes hoildays from the total
number of days per week. Do you know how can I modify the formula to
exclude holidays?

Thanks for your help.