=A2-weekday(a2,2)+1

or
="Week commencing " & Text(A2-weekday(a2,2)+1,"dd/mm/yyyy")

--
Regards,
Tom Ogilvy


"RJG" wrote in message
ups.com...
I have used
"=weeknum(A2;2)"
to covert actual dates into the week of the year into which they
fell.ie 009/02/2006 is in week 7.

I now want to be able to have a column heading that reads "Week
comencing 02/022006", so I need to convert week7 back to the first
day(monday) of that week.

Is this possible, if so how.

Bob