ExcelBanter - CONCATENATE TODAY()

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - CONCATENATE TODAY() (https://www.excelbanter.com/excel-discussion-misc-queries/128204-concatenate-today.html)

Charlie Bravo

CONCATENATE TODAY()

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 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

Dave Peterson

CONCATENATE TODAY()

Another:

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

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

--

Dave Peterson

All times are GMT +1. The time now is 02:42 AM.