Autofind First weekday

[freud1]

Hi Guys,

Im working on a spreadsheet which has a column of dates formatted in "dd/mm/yy" there are always 365 days listed but these could be between any period.

I am trying to create a table which looks up all mondays, tuesdays etc ....

I need a formula to find the first monday in the list and then to fill the rest of the tables.

So far I manually input the monday and the rows below use =previous row + 7 to fill the following mondays, then in the next section it will refer to the monday and +1 to populate tuesday then the +7 in the rows below.

Ideally i would like a system which would log these dates automatically, the trouble is, sometimes the Thursday or another day will be first ( eg if the raw data is between 01/01/09 - 30/12/09 then the 01/01/09 is a thursday so the first thursday is 01 but the first monday will be 04/01/09.

I have uploaded the spreadsheet for your reference

Any help would be greatly appreciated.

Many thanks