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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formula to calculate month-month	User	Microsoft Excel Misc	2	16th Feb 2010 10:28 AM
Re: How to calculate month	Jeff Boyce	Microsoft Access Queries	0	10th Oct 2008 11:29 PM
calculate month	=?Utf-8?B?Uko=?=	Microsoft Excel Worksheet Functions	9	25th Sep 2008 03:06 PM
Calculate the first day of the month for the current month?	=?Utf-8?B?QXByaWwgUy4=?=	Microsoft Excel Misc	5	27th Jul 2005 08:53 PM
How do I calculate the first day of the next month following a ce.	=?Utf-8?B?VmVyb25pY2E=?=	Microsoft Excel Worksheet Functions	0	18th Sep 2004 12:49 AM