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

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

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

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

"Sunnyskies" wrote:

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