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
|