Google-sheets – Filter how many dates out of the dates in range are equal to Today

google sheets

I'm using a Google Sheets spreadsheet as a more flexible to-do list app alternative.

How would I create a filter for how many tasks are due today out of a range of =DATE... cells. I've tried using =FILTER and =COUNT formulas but have never been able to get it to work. How would I do this?

This is the spreadsheet

I need to filter how many dates out of the dates in B2:B14 are =TODAY().

Best Answer

There are many ways to do this. Try this one:

=counta(iferror(filter(B2:B, B2:B = today())))

The benefit of this pattern is that you can easily add more conditions to the filter().

Related Topic