In #1 you wrote that you had a one column list. I based my proposal on that. It requires that you use helper cells in B1:B10 as indicated.
If Logit's solution works for you then do use it, but as he mentions it counts anything that is a number.
Also if not a date.
|