You could use this with a helper column,

=SUMPRODUCT(--(WEEKDAY(DATE(2006,1,K1:K31),1)=2))

Where K1:K31 contains the numbers 1 - 31 and "=2" is the day of the

week you are looking for (1=Sun, 2=Mon...)

If you don't want to use a helper column just type out the numbers in

the formula where the K1:K31 range is like {1,2,3,4,,,,,,31}.

HTH

Steve

--

SteveG

------------------------------------------------------------------------

SteveG's Profile:

http://www.excelforum.com/member.php...fo&userid=7571
View this thread:

http://www.excelforum.com/showthread...hreadid=545867