I have a date (11/30/2007) stored in a cell on my worksheet. In another cell
I would like to display "Today is 11/30/2007" using the stored cell value.
Is there a function I can use to do this?

="Today is "&TEXT(A1,"mm/dd/yyyy")

--


Regards,


Peo Sjoblom


"ginnyst" wrote in message
...
I have a date (11/30/2007) stored in a cell on my worksheet. In another
cell
I would like to display "Today is 11/30/2007" using the stored cell value.
Is there a function I can use to do this?

Hi Ginny -

No need for a function to do this ... just link the 1st cell into the
2nd cell (ie, in D3, enter =A3) and then use a custom format on cell
D3.
FormatCells...Number-Custom"Today is "MM/DD/YYYY

Hi ,

Assume your date is in cell A1 and is in the format mm/dd/yyyy, then type
the below formula in target cell

="Today is " & TEXT(A1,"mm/dd/yyyy")

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"ginnyst" wrote:

I have a date (11/30/2007) stored in a cell on my worksheet. In another cell
I would like to display "Today is 11/30/2007" using the stored cell value.
Is there a function I can use to do this?

Another way if you want today's date


="Today is "&TEXT(TODAY(),"mm/dd/yyyy")


--


Regards,


Peo Sjoblom





"Peo Sjoblom" wrote in message
...
="Today is "&TEXT(A1,"mm/dd/yyyy")

--


Regards,


Peo Sjoblom


"ginnyst" wrote in message
...
I have a date (11/30/2007) stored in a cell on my worksheet. In another
cell
I would like to display "Today is 11/30/2007" using the stored cell
value.
Is there a function I can use to do this?