0

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

1
  • 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
0

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

2

Your Answer

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