EASY: Format NOW as mm/dd/yyyy

P

pauloreiss

I have this simple function:

="Sales of: " & NOW()

But this way the date is appears with that Excel code like
33046,30184. I wanted to show 04/28/2006.
What is the function to set a format for the variable?

Something like =formatdate(now();mm/dd/yyyy)

Thanks!
 
R

Ron Coderre

Actually, you're pretty close....try this:

="Sales of: " & TEXT(TODAY(),"MM/DD/YYYY")

Does that help?

Regards,
Ron
 
Top