Count Dates?
That is a bit difficult as a date is just a number, so testing the value 1
would say that is a valid date.
This formula counts the cells A1:A10 that have numbers that equate to dates
between 1st Jan 2000 and today. Adjust to suit
=SUMPRODUCT(--ISNUMBER(MATCH(ROW(INDIRECT(--"2000-01-01"&":"&TODAY())),A1:A10,0)))
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"msnews.microsoft.com" wrote in message
...
Can anyone advise how to count the number of cells containing dates in the
range A1:A1000. Is there a condition I can use in COUNTIF?
If it helps, the dates are customer formatted as dd.mm.yy
Many thanks,
Jason
|