View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default CONCATENATE TODAY()

=CONCATENATE("Results as of "&TEXT(TODAY(),"mmmm dd yyyy"))
--
Gary''s Student
gsnu200703


"Charlie Bravo" wrote:

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