| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formula
i am trying to get a cell to say "week starting (todays date).
so i put in the following formula ="week starting"&" "&TODAY() however the result was week starting 38990 any ideas? and i need it all in the one cell so seperating the text and date is not an option thanx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formula
sorry folks have figured it out no need for help
in case any body is curious solution was: format cell with custom formatting and add week starting as text befor date format thanx "max power" wrote: i am trying to get a cell to say "week starting (todays date). so i put in the following formula ="week starting"&" "&TODAY() however the result was week starting 38990 any ideas? and i need it all in the one cell so seperating the text and date is not an option thanx |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel formula
On Sat, 30 Sep 2006 00:28:01 -0700, max power
wrote: i am trying to get a cell to say "week starting (todays date). so i put in the following formula ="week starting"&" "&TODAY() however the result was week starting 38990 any ideas? and i need it all in the one cell so seperating the text and date is not an option thanx ="week starting " & TEXT(today(),"mm/dd/yy") --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Excel Formula Issue | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
