Date and Time Function
 

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

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

Date and Time Function
 

=COUNTIF(A1:A10,"="&--"2006-10-03")-COUNTIF(A1:A10,"="&--"2006-10-04")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Joey041" wrote in message
...
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

Date and Time Function
 

Another way

=SUM(INDEX((INT(A1:A10)=--"2006-10-03")*1,0))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Joey041" wrote in message
...
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

Date and Time Function
 

THANK YOU!!!!
--
Very Thankful


"Joey041" wrote:

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

Date and Time Function
 

which did you use?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Joey041" wrote in message
...
THANK YOU!!!!
--
Very Thankful


"Joey041" wrote:

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