Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I count cells in a column of dates between date ranges?
I have a column of submission dates in the format 01/01/05, and I need to
count the occurances of dates between certain values... for example, count how many submissions there were between 02/01/05 and 09/01/05 |
#2
|
|||
|
|||
Put your start date in C1, and your end date in D1, and try this:
=SUMPRODUCT((A1:A100=C1)*(A1:A100<=D1)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Andrew82" wrote in message ... I have a column of submission dates in the format 01/01/05, and I need to count the occurances of dates between certain values... for example, count how many submissions there were between 02/01/05 and 09/01/05 |
#3
|
|||
|
|||
Andrew82 wrote:
I have a column of submission dates in the format 01/01/05, and I need to count the occurances of dates between certain values... for example, count how many submissions there were between 02/01/05 and 09/01/05 =COUNTIF(DateRange,"="&X2)-COUNTIF(DateRange,""&Y2) where X2 houses a date like 02/01/05 and Y2 a date like 09/01/05 with X2 <= Y2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
Formula that will count between dates ranges | Excel Worksheet Functions | |||
Counting the number cells between two dates | Excel Discussion (Misc queries) | |||
Formula that will count between dates ranges | Excel Worksheet Functions | |||
Count non-colored cells | Excel Discussion (Misc queries) |