COUNTIFS with Specific Dates
I'm working on a Pre-COVID and COVID list and could use some help. Can someone take a look?
One example: We need to COUNT how many times TRB was used during the dates of January 1st, 2020 to March 13, 2020.
=COUNTIFS(Division:Division, CONTAINS("TRB", @cell)), ([EventDate, >DATE(2020, 1, 1):EventDate, <DATE(2020, 3, 13)])
Help Article Resources
Check out the Formula Handbook template!