CONCATENATE TODAY()

[Charlie Bravo]

Hi,

I am using the formula =CONCATENATE("Results as of "&TODAY()) but the date
comes out as a number. How can I get it to display as a formatted date so it
looks like "Results as of January 29, 2007"?

Charlie

 

[Gary''s Student]

=CONCATENATE("Results as of "&TEXT(TODAY(),"mmmm dd yyyy"))

 

[Dave Peterson]

Another:

="Results as of " & text(today(),"mmmm dd, yyyy")