Use the WEEKDAY and COUNTIF functions.

Column A is dates. In column B next to dates enter,

=WEEKDAY(A2,1)

to determine the day of the week. This calculates the weekday starting
with Sunday as 1.

I typed in the days of the week in cells E1:K1 starting with Sunday.

In E2,

=COUNTIF($B$2:$B$32,"=1")

Change the condition from "=1" to "=2" up to "=7" for Monday - Saturday
in the rest of the range F2:K2.

HTH

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=491821