So, I'm trying to build a call tracker for myself to help track my calls but I'm having trouble with the COUNTIFS function. All the searches on Google were helpful and the formula looks right but it's not returning the correct value.
I have three named ranges that reference to table data. CALLCAMPAIGN, CALLDATE, and CALLDISPO (this last one isn't used yet as I'm stuck figuring out this issue).
The formula to pull by a single staticly set date works fine - =COUNTIFS(CALLCAMPAIGN,$A5,CALLDATE,B$1)
But I want to have two cells that contain the Start Date and End and have the formula count all the calls between those dates. The formula I've tried is
=COUNTIFS(CALLCAMPAIGN,$A5,CALLDATE,">="&$F$1,CALLDATE,"<="&$F$2)
But instead of returning 1 for the date range I put, it is returning 0 and I can't figure out why. Any suggestions? File is attached.