Find knowledge base article(s) by searching for keywords in the title e.g. type linux in the search box below
Find knowledge base article(s) by browsing the subject categories of articles
Technology quick references, cheatsheets, user manuals etc.
Shop Online through ShopifyLite
Tutorials on various IT applications.
Search Title    (UL:0 |SS:f)

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)
[ © 2008-2021 myfaqbase.com - A property of WPDC Consulting ]