Date and Time Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Say 10/3/2006 is in B1, then
=SUMPRODUCT(--(INT(A1:A10)=$B$1))

Regards,
Stefi

„Joey041†ezt írta:
 
=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)
 
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)
 
which did you use?

--

HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A challenge for an Excel Master... 9
WCG Stats Saturday 19 August 2023 3
WCG Stats Sunday 16 October 2022 2
WCG Stats Sunday 20 August 2023 3
Countifs or a pivot 1
WCG Stats Friday 26 May 2023 3
Date 8
Long Date - Long Date = text is days 2

Back
Top