One way:

="Sales of: " & TEXT(TODAY();"mm/dd/yyyy")


In article ,
pauloreiss
wrote:

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!