| 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 |
| 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) | |||
Threaded Mode
