Use COUNTIFS function on results of DATEVALUE function?

Hi Si,

First you will need to find the bad dates and missing dates in your data so each has a valid date. Then I assume you want some kind of counts per the between dates. See the attached Pivot Table where I've done that using Excel 2013. I believe it is also possible in 2007 but think you can do it. ALSO - you will need to add column headers to each column so Excel can deal with your data as a table. Duplicate head names or missing head names aren't allowed. See the attached and start looking at Pivots for a possible answer.