CountIf with Date range

lnelsen ✭✭
edited 09/06/22 in Formulas and Functions

I am trying to count the number of requests types between a date range.  This is what I thought would work:  

=COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 02:2019, 03, 14)))

I am using this formula to count the entire column =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5) and it works fine.  When I throw the date range into the mix, I am no longer getting results.

Any suggestions would be appreciated!

Screen Shot 2019-04-08 at 3.32.57 PM.png

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!