How do I calculate number of Mondays in a given month in Excel?
 

I'm trying to get Excel to calculate the number of Mondays, Tuesdays, etc in
a given month but I haven't found a function that addresses this task. Any
ideas?

How do I calculate number of Mondays in a given month in Excel?
 

Hi

Have a look he
http://www.cpearson.com/excel/DateTimeWS.htm
It's on that page - somewhere - along with tons of other useful stuff!

Andy.

"Rossta" wrote in message
...
I'm trying to get Excel to calculate the number of Mondays, Tuesdays, etc
in
a given month but I haven't found a function that addresses this task.
Any
ideas?

How do I calculate number of Mondays in a given month in Excel?
 

=4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-DoW))

where DoW is the day number to test, 1 Sun, 2 Mon

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Rossta" wrote in message
...
I'm trying to get Excel to calculate the number of Mondays, Tuesdays, etc
in
a given month but I haven't found a function that addresses this task.
Any
ideas?

How do I calculate number of Mondays in a given month in Excel?
 

You could use this with a helper column,

=SUMPRODUCT(--(WEEKDAY(DATE(2006,1,K1:K31),1)=2))

Where K1:K31 contains the numbers 1 - 31 and "=2" is the day of the
week you are looking for (1=Sun, 2=Mon...)

If you don't want to use a helper column just type out the numbers in
the formula where the K1:K31 range is like {1,2,3,4,,,,,,31}.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=545867