Thread: Calculate no. of Sundays in a month
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default Calculate no. of Sundays in a month
On Jun 13, 2:34*pm, Nacho wrote:
What about if you wnat to know the no. of Sundays, but just from a single
cell, say A1=3/1/2007

The following allows A1 to be any date within the month.

=SUMPRODUCT(--(WEEKDAY(EOMONTH(D9,-1)+ROW($A$1:INDIRECT("$A
$"&DAY(EOMONTH(D9,0)))))=1))
Reply With QuoteReply With Quote