All,

I am trying to build out some reporting for data that is exported in the same format as I have attached.

I have it built so the user can enter in a 'start' and 'end' date and the data will calculate appropriately. Unfortunately, when the data I need is exported, it has a timestamp included. I think it is also in an odd format.

Can anyone get a countif to work with the data I have attached?

Example: How many dates are between 8/21 and 8/29?

Thank you for whomever took the time to read this.


-JDate Help.xls