Thread: How do I calculate number of Mondays in a given month in Excel?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote