Hi All,

I am trying to use a straight forward =COUNTIFS($A$2:$A$14,"<>"&" ") to count non blank date cells (i have a number of criteria but slimming down to 1 for example). I tried "*" as well but it doesn't seem to be working. I believe it is because I am counting in columns set using data validation drop down. Please see attached spreadsheet, appreciate all the help!

Dates
8/23/2018 COUNTIFS($A$2:$A$14,"*") 0
8/23/2018 COUNTIFS($A$2:$A$14,"<>"&" ") 13

8/29/2018
8/23/2018
8/23/2018

8/23/2018
8/23/2018

8/23/2018
8/29/2018
8/23/2018


Cheers

STF