| 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 |
| 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 | |||
Threaded Mode
