The formula checks for each date if it is Sunday using TEXT() function and then return and array of zero and ones that is summed up to give you the answer
Category: Math and trigonometry
Adds its arguments
Formats a number and converts it to text
TEXT(Value you want to format, “Format you want to apply to that value”)
Category: Lookup and reference
Returns the row number of a reference
Returns a reference indicated by a text value
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM