I need a macro that will populate columns with W/C dates and the dates of any
part weeks where the end of the month falls within a certain week.

E.g. If Cell A1 has the date 02/01/06, I'd like cell B1 to show 09/01/06 and
so on until the end of the year. However where the end of the month falls
within Monday - Friday I need the week commencing date prior to the end of
the month to be shown, such as 30/01/06 and then the next column to show
01/02/06. The next column would then start again to show week commencing
dates. And so on and so on.