today functions

  • Thread starter Thread starter diggs
  • Start date Start date
D

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
 
How do you want the date, like mm/dd/yyyy?


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

--


Regards,


Peo Sjoblom
 
diggs said:
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
Click to expand...


="Status as of "&TEXT(TODAY(),"mmmm dd, yyyy")&" @ 0600"
 
The TODAY() function will update tomorrow.

Is that what you want?


Gord Dibben MS Excel MVP
 
Back
Top