Count the number of projects completed within a 1 week period.

Hello,

This is my first post, I hope I provide enough information.

Example: A1:A100 would be project name, B1:B100 would be project start date, B2:B100 would be project completion date.

I want to know how many projects were completed during each week (monday to Friday) (additional purpose is to graph the cumulative weekly completed projects) and I need a formula that will allow for that. I have 'dallied' with the sum and sumproduct functions but have not been successful.

I am using Excel 2007
HELP!