Format NOW function
 

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

Format NOW function
 

="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

Format NOW function
 

Hi Todd, try this -

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"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