I need to simplify a `CountIF`

formula.

Instead of having a date range I just need my `COUNTIF`

to count cells cointaining dates disregarding date range period.

I have tried for example simplifying it by just `=Countif(E84:H91),"Dates"`

. I have also tried `=CountIf(E84:H91),"dd.mm.yy"`

with no luck.

This is probably going to be facepalm easy but any formula suggestion appreciated, or should I be using a different Count Function all together? I have heard/seen the `Dcount`

function but never used. Could that be a better option?

canbe interpreted as a date in Excel. I am not sure there is a way to do this without using a UDF. Can you safely make any assumptions about the data, e.g., "All cells containing a`/`

contain Date values"? If so, I have an idea that doesn't require any VBA. – David Zemens Apr 23 '13 at 2:40