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

S

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top