Putting a date in a sentence dynamically.

[Jeff K]

Okay, A1 contains a date - 8/1/2003.
I want B3 to read WEEK OF 8/1/2003 using the date from
A1.
So, in B3 I enter =concatenate("WEEK OF ", A1)
and I get WEEK OF 37834

I understand what's happending but can't find a function
which will convert a serial code to a date. They all
seem to work the other way.

I know that I could just put the text in one cell and the
date in the next but it wouldn't be as elegant. And what
if I had text to put in the sentence after the date?

Any help would be appreciated.

Jeff K.

 

[Lynn]

You could also go to Format\Cell\Custom and type in "Week
of" followed by your preferred date format.

 

[tc]

Dear Jeff

you may use the following formula

="Week of "&text(a1,"d/m/yyyy")

Yours sincerely,

TC