Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Dates in Count functions
I want to create a CountIf function using dates but it gives me "0s".... How
do I use dates in these situations. For example, COUNTIF(A1:A10<11/1/04.... Thanks! |
#2
|
|||
|
|||
Try
=COUNTIF(A1:A10,"<"&DATE(2004,11,1)) Regards, Peo Sjoblom "HWade" wrote: I want to create a CountIf function using dates but it gives me "0s".... How do I use dates in these situations. For example, COUNTIF(A1:A10<11/1/04.... Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do a count dates? | Excel Discussion (Misc queries) | |||
How do a count dates? | Excel Discussion (Misc queries) | |||
I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Count occurences between dates | Excel Worksheet Functions | |||
count the no.of records between two dates | Excel Worksheet Functions |