|
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 |
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 |
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 |
| All times are GMT +1. The time now is 02:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com