| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
="my text" &TODAY()
The above will return a date value (regardless of how I format the cell it's
in) rather than the date. Clever as this is, it's of no use to me whatsoever. What I want is: Logged today - 03/Jul but what I get is Logged today - 39267 Answers on a postcard please... -- tia Jock |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
="my text" &TODAY()
Try:-
="Mytext " & TEXT(TODAY(),"dd:mm:yyyy") Mike "Jock" wrote: The above will return a date value (regardless of how I format the cell it's in) rather than the date. Clever as this is, it's of no use to me whatsoever. What I want is: Logged today - 03/Jul but what I get is Logged today - 39267 Answers on a postcard please... -- tia Jock |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
="my text" &TODAY()
Thanks Mike. You saved the day yet again. Brill.
Jock "Mike H" wrote: Try:- ="Mytext " & TEXT(TODAY(),"dd:mm:yyyy") Mike "Jock" wrote: The above will return a date value (regardless of how I format the cell it's in) rather than the date. Clever as this is, it's of no use to me whatsoever. What I want is: Logged today - 03/Jul but what I get is Logged today - 39267 Answers on a postcard please... -- tia Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "NOW" or "TODAY" date function | Excel Worksheet Functions | |||
| How can I use the "TODAY ()" Function in an "IF/THEN" calculation | Excel Worksheet Functions | |||
| IF(D2="Paid","",IF(C2="","",IF(TODAY()<C2,"",IF(TODAY()-C214,"Ove | Excel Discussion (Misc queries) | |||
| =IF((TODAY()-B8)30, "Overdue", "Current"), | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Hybrid Mode
