| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display DAY
Is it possible for the current day to be displayed automatically? i.e. Mon or Tue etc. -- David Bateman ------------------------------------------------------------------------ David Bateman's Profile: http://www.excelforum.com/member.php...o&userid=29294 View this thread: http://www.excelforum.com/showthread...hreadid=490105 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display DAY
Enter =today() in a cell and format as ddd
-- Gary''s Student "David Bateman" wrote: Is it possible for the current day to be displayed automatically? i.e. Mon or Tue etc. -- David Bateman ------------------------------------------------------------------------ David Bateman's Profile: http://www.excelforum.com/member.php...o&userid=29294 View this thread: http://www.excelforum.com/showthread...hreadid=490105 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display DAY
In Cell A1 enter:
="Today is " & TEXT(TODAY(),"dddd") "David Bateman" wrote in message news:David.Bateman.1zerjz_1133519401.8331@excelfor um-nospam.com... Is it possible for the current day to be displayed automatically? i.e. Mon or Tue etc. -- David Bateman ------------------------------------------------------------------------ David Bateman's Profile: http://www.excelforum.com/member.php...o&userid=29294 View this thread: http://www.excelforum.com/showthread...hreadid=490105 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I don't want to display any controls in excel. | Excel Discussion (Misc queries) | |||
| Look Up and Display set data | Excel Discussion (Misc queries) | |||
| How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Hybrid Mode
