Format NOW function

[Todd Huttenstine]

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

 

[Tom Ogilvy]

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

 

[Ken Wright]

Hi Todd, try this -

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