| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM (TODAY thru EOM) | Excel Discussion (Misc queries) | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| AVERAGE / OFFSET FUNCTIONS, TODAY.. | Excel Discussion (Misc queries) | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
Linear Mode
