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().

  • Welcome to Web Applications. Please show what you tried (add the complete formulas) directly in the question body and add a brief description of your search efforts as is suggested in How to Ask.
    – Rubén
    May 8 at 20:29

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().


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy