Calculate Number Of Business Days Between Two Dates and Allocate Them Across Week End

Hi Excel Experts,

I have a problem that i cant seem to figure out.

I have a Huge spreadsheet with start and end dates in column A & B respectively.

cell D1 to Z1 I have Weekending Dates Starting from Weekending 5/Feb/10

My problem is when the user enters in a start date of say 1/feb/2010 and an end date of 10/feb/10 in cells A2 and B2 respectively, i want a formula in cells D2 to Z2 that will calculate How many business days of this Start and End Date Fall within the weekending date.* This then needs to be dragged down..

So in the example above, if the start date is 1/Feb/2010 and an end date is 10/feb/10 in cells A2 and B2. Than in Cells D2 which has the Weekending Title of 5/Feb/10 should auto calculate the result of 5. Then in cell E2 which has the weekending title of 12/Feb/10 should auto calculate the result of 3. Because there are no business days for F2 which has the weekending title of 19/Feb/10, that are triggered by the start and end date above, than this should auto calculate 0.

And so forth..

I tried everything i know but i cant get this to work..

Pleeeassee help meeeeee..

thankyou soooooo much everyone.. I look forward to your formula solutions

I have attached a sample spreasheet that highlights this problem

thank you all....

THANK you SOOOOOO Much buddy.. your a life saver... and a legend..

Also cross-posted here