today functions

[diggs]

I want to be able to put the following on a spreadsheet: Status as of August
15, 2008 @ 0600. I used the following formula: ="Status as of "&TODAY()&" at
0600". The problem is that I do not know how to make the text stay text
formatting and the date go to date formating. I know that I could do it in
adjacent cells but it does not look very clean due to the change in length.
Thank you in advance for the support.
C.Diggs

 

[Peo Sjoblom]

How do you want the date, like mm/dd/yyyy?


="Status as of "&TEXT(TODAY(),"mm/dd/yyyy")&" at 0600"

--


Regards,


Peo Sjoblom

 

[Glenn]

I want to be able to put the following on a spreadsheet: Status as of August
15, 2008 @ 0600. I used the following formula: ="Status as of "&TODAY()&" at
0600". The problem is that I do not know how to make the text stay text
formatting and the date go to date formating. I know that I could do it in
adjacent cells but it does not look very clean due to the change in length.
Thank you in advance for the support.
C.Diggs

="Status as of "&TEXT(TODAY(),"mmmm dd, yyyy")&" @ 0600"

 

[diggs]

That was it thanks

="Status as of "&TEXT(TODAY(),"mmmm dd, yyyy")&" @ 0600"

 

[Gord Dibben]

The TODAY() function will update tomorrow.

Is that what you want?


Gord Dibben MS Excel MVP