Text String with Today() function

[spg2112]

Hello all,

I want the following formula to return this:

As of: 05/08/2002

Here's what I have: ="As of "&today()

I get the date in text format (ie. 37384). How can I get what I want here?

 

[Mark O'Brien]

Does formatting the cell as a Data work?

 

[spg2112]

No that doesn't work.

 

[Aladin Akyurek]

Is it not:

="As of: "&TEXT(TODAY(),"mm/dd/yyyy")

 

[spg2112]

Yes Aladin! That would be it. Thanks

Steve

 

[RJB78]

Is it not:

="As of: "&TEXT(TODAY(),"mm/dd/yyyy")


Is it possible to add text after the date too, say you wanted it to read: "as of (today's date) and subject to change and availability

 

[AlanY]

="As of: "&TEXT(TODAY(),"mm/dd/yyyy")&" subject to change and availability"

 

[RJB78]

Thank you

 

[AlanY]

welcome