Hi all,

There is a speadsheet at work with a column which has a range of dates (from 18/05/2003 - date) which information gets drawn from every Friday. The information needed from the column is pretty simple but lengthy to expalin. For example...

http://xs511.xs.to/xs511/07043/shot1.png

As you can the dates are in no order...and need to stay that way. The information needed every week is shown here...

http://xs311.xs.to/xs311/07043/shot2.png

I have got the formula for the number of enteries between each date but strugling with the earliest date within the dates. I can do it manually by auto filtering the column and looking for the date closest to the earliest date but this is long.

The dates change on a weekly basis...just to throw a spanner in the works.

Any help offered is appreciated.

Thank You.