2

I have a column of dates as so...

dates

I want to count the number of Saturdays (or any other day of the week), in this column. One solution would be two create an extra column with the weekday number in it, and then run a COUNTIF formula over that column, such as...

A Solution

But I would prefer to not create a new column. How can I do this?

player0
  • 124,011
  • 12
  • 67
  • 124
Mr. J
  • 1,524
  • 2
  • 19
  • 42

2 Answers2

2

Try the following formula:

=filter(text(A:A,"dddd"),len(A:A))

and then:

=countif(filter(text(A:A,"dddd"),len(A:A)),"Sunday")
Kishan
  • 1,630
  • 13
  • 19
0

you don't need extra column, just:

=INDEX(COUNTIFS(WEEKDAY(A:A), 7, A:A, "<>"))

enter image description here

or shorter:

=COUNTA(FILTER(A:A, WEEKDAY(A:A)=7))

0

player0
  • 124,011
  • 12
  • 67
  • 124