Putting a date in a sentence dynamically.

  • Thread starter Thread starter Jeff K
  • Start date Start date
J

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.
 
You could also go to Format\Cell\Custom and type in "Week
of" followed by your preferred date format.
 
Dear Jeff

you may use the following formula

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

Yours sincerely,

TC
 
Back
Top