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 |