| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting based on two dates
I have two columns which both contains dates. I want a count based on
criteria from the dates. For example... Start Date End Date 01/01/08 12/31/08 3/15/07 12/01/09 5/5/09 10/01/09 10/01/08 How would i get a total count of items that started before 06/01/08 and ended after 06/01/09. it would be 1 in the example above. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting based on two dates
Try this
=SUMPRODUCT((A2:A20DATE(2008,6,1))*(B2:B20<DATE(2 009,6,1))) Mike "AccessNoviceButTrying" wrote: I have two columns which both contains dates. I want a count based on criteria from the dates. For example... Start Date End Date 01/01/08 12/31/08 3/15/07 12/01/09 5/5/09 10/01/09 10/01/08 How would i get a total count of items that started before 06/01/08 and ended after 06/01/09. it would be 1 in the example above. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting based on two dates
With start and end dates in cells c1 and D1 try the below
=SUMPRODUCT((A2:A10<C1)*(B2:B10D1)) If this post helps click Yes --------------- Jacob Skaria "AccessNoviceButTrying" wrote: I have two columns which both contains dates. I want a count based on criteria from the dates. For example... Start Date End Date 01/01/08 12/31/08 3/15/07 12/01/09 5/5/09 10/01/09 10/01/08 How would i get a total count of items that started before 06/01/08 and ended after 06/01/09. it would be 1 in the example above. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting dates based on certain criteria | Excel Worksheet Functions | |||
| Counting based on location & dates | Excel Discussion (Misc queries) | |||
| Counting based on location & dates | Excel Discussion (Misc queries) | |||
| Counting based on location & dates | Excel Discussion (Misc queries) | |||
| Counting based on location & dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
