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

sbooth · Mar 3, 2009

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 · Mar 3, 2009

the search function works:

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

barry houdini · Mar 3, 2009

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