Bob,

Try

="week com
"&TEXT(TODAY()-WEEKDAY(TODAY();3)-7*WEEKNUM(TODAY()-WEEKDAY(TODAY();3))+L1*7
,"mm/dd/yyyy")


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"RJG" wrote in message
oups.com...
Sorry to be stupid but I am not a regular excel user,

As you correctly state the above gives a number (38733) in the required
cell, if I click on format cell then I can get the number to show
corrctly as 16/01/2006. However as soon as I include text with it the
formatting dissapears and reverts back to the number. Is there anyway I
can format the following straight into the required "Week com
16/01/2006".

="week com
"&TODAY()-WEEKDAY(TODAY();3)-7*WEEKNUM(TODAY()-WEEKDAY(TODAY();3))+L1*7

With thanks

Bob