Help with a date formula to copy a w/c date

[watchthisspace]

Hello

Im after a little help to see if something is possible.

I have a spreadsheet which column a is the days for the week, column b is the date. In column C I have the w/c date.

Is there a formula I can use instead of manually typing (or copying) the week comencing date.

Any help would be really useful

Thanks

[TMS]

Please Login or Register  to view this content.

formatted as

Please Login or Register  to view this content.

[TMS]

A1 could be just

Please Login or Register  to view this content.

formatted as

Please Login or Register  to view this content.

[Phuocam]

Or try this ...

="w/c "&DAY(B1-MOD(B1-2,7))&MID("thstndrdth",MIN(9,2*RIGHT(DAY(B1-MOD(B1-2,7)))
*(MOD(DAY(B1-MOD(B1-2,7))-11,100)>2)+1),2)&TEXT(B1-MOD(B1-2,7)," mmmm")