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.
Bookmarks