| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| USING THE NESTED IF FUNCTION TO SEE IF A TIME DATE VALUE IS T OR F | Excel Discussion (Misc queries) | |||
| Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| Date & Time function | Excel Worksheet Functions | |||
Linear Mode
