Formula for counting the number or Mondays in a month - Help Needed

[sbooth]

I need a formula that will calulate the total number of Mondays, Tuesdays, Wednesdays...etc. in a given month. In my spreadsheet I have the days in cells A2:A9. In Cells B1:B:12 I have the months in this format 7/1/09..thru 6/1/10.

Any help would be appreciated.

Thanks,
Steve

 

[PaddyD]

the search function works:

http://www.mrexcel.com/forum/showthread.php?t=306370&highlight=number+mondays+month

 

[barry houdini]

Not sure about your layout Steve, but here's a generic formula to give number of a specific day in a month

=4+(DAY($A3+34)< WEEKDAY($A3-B$2))

where A3 contains 1st of the relevant month and B2 contains a number 1 to 7 representing Sunday [1] through to Saturday [7]

See below: Note B2:H2 contains the numbers 1 to 7 custom formatted as dddd

days in month (4 or 5).xls
	A	B	C	D	E	F	G	H	I	J
1
2		Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Total
3	1/1/2009	4	4	4	4	5	5	5	31
4	2/1/2009	4	4	4	4	4	4	4	28
5	3/1/2009	5	5	5	4	4	4	4	31
6	4/1/2009	4	4	4	5	5	4	4	30
7	5/1/2009	5	4	4	4	4	5	5	31
8	6/1/2009	4	5	5	4	4	4	4	30
9	7/1/2009	4	4	4	5	5	5	4	31
10	8/1/2009	5	5	4	4	4	4	5	31
11	9/1/2009	4	4	5	5	4	4	4	30
12	10/1/2009	4	4	4	4	5	5	5	31
13	11/1/2009	5	5	4	4	4	4	4	30
14	12/1/2009	4	4	5	5	5	4	4	31
15
16	Totals	52	52	52	52	53	52	52	365
17
Sheet1