Is it possible for the current day to be displayed automatically? i.e. Mon or Tue etc.
Is it possible for the current day to be displayed automatically? i.e. Mon or Tue etc.
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
>
>
In Cell A1 enter:
="Today is " & TEXT(TODAY(),"dddd")
"David Bateman" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks