=SUMPRODUCT(--ISNUMBER(A1:A100))

adjust to suit


"MsSealy" wrote:

I am working on a worksheet that is all dates. I have 5 things(dates) that
need to happen in order for me to to count it as 1. How do I set up a
function to say that...and if there is not date not to count it?

PLEASE HELP ME!!!