Can I concatenate with DATE

  • Thread starter Thread starter JAFUNE
  • Start date Start date
J

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
 
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
 
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.
 
Back
Top