calculate how many Mon, Tue, Wed, Thur, Fri, Sat & Sun in month

[Sunnyskies]

Afternoon from Sunny RSA,

Looking for a formula that will calculate how many Days (M, T, W, T, F, S &
S) in a particular month (cell c5).

Example:
2008/04/01 (c5) [Formated as mmmyy)
M (c7) = 4
T (c8) = 5
W (c9) = 5
T (c10) = 4
F (c11) = 4
S (c12) = 4
S (c13) = 4

Thanks

 

[Mike H]

Hi,

Try this

=SUMPRODUCT(--(WEEKDAY(EOMONTH($C$5,-1)+ROW($A$1:INDIRECT("$A$"&DAY(EOMONTH($C$5,0)))))=ROW(A1)))

Array enter for Sundays then drag down to Monday etc

Mike