Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a column of data with dates within it. I need to then search this
column for the number of times these dates appers between 2 dates. ie. Column A Column D ColumnE Column F 1 22/04/2007 21/04/2007 28/04/2007 05/05/2007 2 23/04/2007 3 28/04/2007 X Y 4 25/03/2007 5 01/05/2007 6 29/02/2007 So in column A there are 3 dates which are greater than 21/04/2007 and less than or equal to 28/04/2007 to give X. There is also 1 date greater than 28/04/2007 & less than or equal to 05/05/2007 to give Y Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Editing countif formulae | Excel Worksheet Functions | |||
formulae problems:HELP | Excel Discussion (Misc queries) | |||
COUNTIF Problems | Excel Discussion (Misc queries) | |||
problems with sumif and countif | Excel Discussion (Misc queries) | |||
Nesting formulae with COUNTIF | Excel Discussion (Misc queries) |