Counting Dates and Finding Earliest

All,
Ive been trying this for a while and seem to be getting no-where. In column A i have a list of dates (in dd/mm/yy format). I need to be able to pull off the following information at any given time:

Number of dates between:
27/06/2004 and 05/07/2006* and the earliest date that falls between these dates
06/07/2006 and 27/09/2006* and the earliest date that falls between these dates
28/09.2006 and TODAY and the earliest date that falls between these dates

Idealy i would like to only have to amend the 2 dates with the (*) as the other dates will auto update.

Does anybody have any ideas how to count the dates that fall between the 2 dates and how to work out the earliest one?

Any help is welcome.

Thanks.

Emma x

Thanks for the reply. Please see attachment. Attachments always describe things better.

Thanks for this daddylonglegs. It looks like it works. But...(there is always a but isnt there?) this list changes every minute so i would need the ranges in column E (EG A2:A8) to extend past the last entry (A8). This throws up good old #value errors. Any suggestions on this?

Hello emma,

I don't see why that would be a problem, if you extend the ranges A1:A8 to something larger the formulas still work OK even if you have blanks or text in those ranges.

If you change the ranges then you need to change all ranges within a formula to the same size, otherwise you may get an error.

If that doesn't fix it can you post the exact formula that gives an error?

daddylonglegs - you hit the nail on the head...i didnt change the range on all the formulas. Here is a copy incase you need it (and i need to refere to it again ).
Thanks for all your help!

Thanks

Attachment this time