number of mondays in a month formula

**TechRetard** · 12-01-2011, 02:45 PM

Trying to find out how many Mondays are in a given month/year

example, A1=1/1/11 answer would be 5
A1=2/1/11 answer would be 4
A1=5/1/11 answer would be 5

**daddylonglegs** · 12-01-2011, 02:49 PM

Try this formula

=4+(DAY(A1+34)<WEEKDAY(A1-1))

**TechRetard** · 12-01-2011, 03:19 PM

Originally Posted by daddylonglegs

Try this formula

=4+(DAY(A1+34)<WEEKDAY(A1-1))

that doesn't work ... check july result

i did find this formula and it seems to work

Please Login or Register  to view this content.

Only question now, for convenience sake, is there any way to fill down the monday dates?

i.e. B1: 1/3/11, B2: 1/10/11, B3: 1/17/11, etc

**arthurbr** · 12-01-2011, 03:54 PM

=SUM(IF(WEEKDAY(A2-1+ROW(INDIRECT("1:"&TRUNC(B2-A2)+1)))=C2,1,0))

Entered as an array formula will give the number of " any day " between two dates where

A2 = begin date
B2 = End date
C2 = weekday ( Sunday=1, Monday = 2, etc..)

**jeffreybrown** · 12-01-2011, 03:57 PM

Originally Posted by TechRetard

Only question now, for convenience sake, is there any way to fill down the monday dates?
i.e. B1: 1/3/11, B2: 1/10/11, B3: 1/17/11, etc

Once you have the first date, =B1+7 and copied down

**daddylonglegs** · 12-01-2011, 04:02 PM

Originally Posted by TechRetard

that doesn't work ... check july result

Apologies, the formula I suggested gives Sundays in the month, for Mondays the -1 should be -2 (and you can adjust for any other day of the week), i.e.

=4+(DAY(A1+34)<WEEKDAY(A1-2))