Excel Formula

[Rick]

I am trying to have text and a formula reside in teh same box with the
date in the format shown (23-May-04). Here is as far as I get...

="Todays date is "&TODAY()

and the results I get is

Todays date is 38131

Rick

 

[DDM]

Rick, here you go:

="Today's date is "& TEXT(TODAY(),"dd-mmm-yy")

 

[Domenic]

Hi Rick,

Try,

="Today's date is "&TEXT(TODAY(),"d-mmm-yy")

Hope this helps!

 

[Dave Peterson]

Or you could give that cell a custom format and just enter the date:

Try:
"Today's date is: "mm/dd/yyyy

As your custom format (Format|cells|number tab|custom category)

 

[Rick]

Found solutions after some weekend reading.

="This is a sample conversion - "&TEXT(NOW(),"dd mmmm yyyy")

Rick

 

[Dave Peterson]

You had very similar solutions suggested, too:

http://google.com/[email protected]
(one line in your browser)

 

[Dan Chupinsky]

This worked for me. Use the formula =TODAY() and the format the cell with
custom format "
todays date is"* d mmmm yy. Good luck.

Dan