Date and Time Function
Say 10/3/2006 is in B1, then
=SUMPRODUCT(--(INT(A1:A10)=$B$1))
Regards,
Stefi
€˛Joey041€¯ ezt Ć*rta:
Is there a way of using COUNTIF for counting all the times listed with
(example) the date 10/3/2006 regardless of the time associated with it?
10/2/2006 7:00
10/3/2006 7:00
10/3/2006 7:30
10/3/2006 8:00
10/4/2006 8:30
10/4/2006 8:00
10/4/2006 8:30
10/4/2006 8:40
10/4/2006 8:50
10/4/2006 8:50
I've tried using a wildcard and tilde after the date but must be doing
something wrong.
--
Very Thankful
|