Software
>>
Applications
>>
Microsoft Office
>>
Excel
>>
What is the formula to count the number of Sundays in a month
Assumes the date for the current month is in Cell C5, otherwise substitute accordingly for the correct Year and Month. =IF(AND(DAY(DATE(Year(C5),Month(C5) 1,1)-1)>28,WEEKDAY(DATE(Year(C5),Month(C5),1),2) >35-DAY(DATE(Year(C5),Month(C5) 1,1)-1)),5,4)
Please enable JavaScript to view the
comments powered by Disqus.