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