If a cell contains any text then add a value (with dates)

Solved/Closed
ryannordgren Posts 7 Registration date Saturday March 4, 2017 Status Member Last seen March 7, 2017 - Mar 4, 2017 at 07:22 PM
ryannordgren Posts 7 Registration date Saturday March 4, 2017 Status Member Last seen March 7, 2017 - Mar 7, 2017 at 07:01 PM
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.
Related:

2 replies

Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 146
Mar 4, 2017 at 08:27 PM
ryannordgren, Good evening.

Try to use:

=SUMPRODUCT(--(WEEKDAY(A1:A30, 2)=1))

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
2
ryannordgren Posts 7 Registration date Saturday March 4, 2017 Status Member Last seen March 7, 2017
Mar 4, 2017 at 11:32 PM
Yes, Thank you! This works.
0
ryannordgren Posts 7 Registration date Saturday March 4, 2017 Status Member Last seen March 7, 2017
Mar 5, 2017 at 12:04 AM
One more question, if you have the time. I can get this to work now for each day of the week except for Saturday. Any idea how to get it to count Saturdays using this same formula?
0