M
Mackem
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.
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.