| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
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. |
| 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) | |||
Threaded Mode
