="The date is: " & Text(NOW(),"mm/dd/yyyy")

--
Regards,
Tom Ogilvy

"Todd Huttenstine" wrote in message
...
I am using the below formula, but I want it to give me a
valid date. What do I need to put in the formula to
return the date as mm/dd/yyyy?

="The date is: " & NOW()

Thanks
Todd Huttenstine