I am looking for help with a formula that will allow me to add up the number of times a certain date is a Monday. I am using =COUNTIF(A1:A30,"*Monday*"). The issue that I have is I am entering dates like 3/6/17 and have the formatting set to show it as "Monday, March 7, 2017." Because Monday was not typed into the cell, it doesn't count it. Is there a way to get the number of Mondays counted?? Please help.
Excel if cell contains date then return value
Count if cell contains any text - Best answers
What values are possible for cells that contain numbers, dates and text? - Best answers
"...Any idea how to get it to count Saturdays using this same formula?..."
Look at this:
WEEKDAY( Serial_number, Return_type)
The WEEKDAY function syntax has the following arguments:
Serial_number: A sequential number that represents the date of the day you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
A number that determines the type of return value.