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.

Hi,

Maybe

=COUNTIF(A1:A6,""&B1)-COUNTIF(A1:A6,""&C1)

Where B1 is the earlier date and C1 is the later date.

Mike

"Mackem" wrote:

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.

Thanks Mike

Worked with no hitches.



"Mike H" wrote:

Hi,

Maybe

=COUNTIF(A1:A6,""&B1)-COUNTIF(A1:A6,""&C1)

Where B1 is the earlier date and C1 is the later date.

Mike

"Mackem" wrote:

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.