How to calculate days of the week in a given time frame

Hi,
I'm trying to count how many Sundays, Mondays, Tuesdays, etc. are in a certain time frame. I would like to enter the time frame as a start date and end date.

For example, how many Sundays, Mondays, Tuesdays, etc. are in the time frame of 1/2/11 - 1/26/11? The number of days would appear in a table below the time frame input.

See my attachment for an example.

Any ideas would be awesome!

Thanks.
-Franklin

Try this in I6 dragged down

=SUMPRODUCT(--($C$3:$C$367>=$H$3),--($C$3:$C$367<=$I$3),--($D$3:$D$367=$H6))

Does that work for you?