COUNTIFS from one date through today with other criteria

Hello!
Needing help creating a formula. The formula has to count all the cells in the "clearance date" column that are blank with the criteria from the "application effective date" which is all dates happening 10.1.2021 through today (which means counting on a rolling basis)
I have this formula below that isn't working:
=COUNTIFS({Clearance Date Range 2}, "", {Application Effective Date Range 1}, AND(@cell >= 2021.10.1))
Any help appreciated!
Answers
-
Hi @JamieH
Instead of writing out the date as a text string, you'll want to use the DATE function so the formula recognizes what numbers represent the day/month/year, etc.
Try something like this:
=COUNTIFS({Clearance Date Range 2}, "", {Application Effective Date Range 1}, @cell >= DATE(2021, 10, 01))
See: DATE Function
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
Check out the Formula Handbook template!