Can I concatenate with DATE

[JAFUNE]

Want to get to:
Current Date: 2/14/2004

But when I concatenate "Current Date" with TODAY() from 2 differen
cells, I get

Current Date: 38031

Here is my code:
="current date: " & TODAY()

Obviously wrong, but not sure why?

Any help appreciated.

Thanks

John F

 

[Vasant Nanavati]

Try:

="Current date: "&TEXT(TODAY(),"m/d/yyyy")

 

[Jacques Brun]

Your formula displays the internal value of the date(serial number)while you want the formatted value of the date
use instead ="current date: "&TEXT(TODAY(),"dd/mm/yyyy"
the TEXT function converts the date from its internal (number of days since January 1st 1900) into its formatted form
I hope it helps

 

[Earl Kiosterud]

John,

One way is to have just the date in the cell:

=TODAY()

And format it (Format - Cells - Number - Custom) to wit:

"Current Date: "m/d/yyyy

Change the m/d/yyyy part to suit.

 

[JAFUNE]

Thanx to everyone. You are terrific, and very helpful!!
Joh