today functions
 

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

today functions
 

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


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

--


Regards,


Peo Sjoblom

"diggs" wrote in message
...
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

today functions
 

diggs wrote:
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"

today functions
 

That was it thanks

"Glenn" wrote:

diggs wrote:
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"

today functions
 

The TODAY() function will update tomorrow.

Is that what you want?


Gord Dibben MS Excel MVP

On Fri, 15 Aug 2008 14:08:12 -0700, diggs
wrote:

That was it thanks

"Glenn" wrote:

diggs wrote:
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"