niallmulhare
New Member
- Joined
- Oct 25, 2006
- Messages
- 2
He I'm hoping someone might be able to help me on this one.
I have a column which contains date and time as follows.
11/25/2006 10:44:00 AM
10/26/2006 12:44:00 AM
12/24/2006 13:44:00 AM
12/25/2006 14:44:00 AM
14/24/2006 15:44:00 AM
10/23/2006 12:44:00 AM
10/15/2006 16:44:00 AM
Wht I'm looking to do it have a query/function that will return all the date's that are the same regardless of the time.
What Kind of query could I use that would return all the dates that are e.g. 10/15/2006 EXCLUDING the time? Is this possible?
Ive tried the following but this only returns 0
=COUNTIF(C2:C100,"11/25/2006")
and e.g. =COUNTIF(C2:C100,"10/25/2006*")
But neither works,
any suggestions would be great.
I have a column which contains date and time as follows.
11/25/2006 10:44:00 AM
10/26/2006 12:44:00 AM
12/24/2006 13:44:00 AM
12/25/2006 14:44:00 AM
14/24/2006 15:44:00 AM
10/23/2006 12:44:00 AM
10/15/2006 16:44:00 AM
Wht I'm looking to do it have a query/function that will return all the date's that are the same regardless of the time.
What Kind of query could I use that would return all the dates that are e.g. 10/15/2006 EXCLUDING the time? Is this possible?
Ive tried the following but this only returns 0
=COUNTIF(C2:C100,"11/25/2006")
and e.g. =COUNTIF(C2:C100,"10/25/2006*")
But neither works,
any suggestions would be great.