Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=today() gives me todays date. What if anything would give me todays weekday
i.e Monday Tuesday etc Best Stew |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Format the text as dddd
On Sep 19, 8:48*am, stew wrote: =today() gives me todays date. What if anything would give me todays weekday i.e Monday Tuesday etc Best Stew |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=TEXT(TODAY(),"dddd")
or simply format the cell as dddd -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "stew" wrote in message ... =today() gives me todays date. What if anything would give me todays weekday i.e Monday Tuesday etc Best Stew |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=TEXT(Today(),"dddd")
"stew" wrote: =today() gives me todays date. What if anything would give me todays weekday i.e Monday Tuesday etc Best Stew |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
thanks everybody
Stew "Dennis" wrote: =TEXT(Today(),"dddd") "stew" wrote: =today() gives me todays date. What if anything would give me todays weekday i.e Monday Tuesday etc Best Stew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUM (TODAY thru EOM) | Excel Discussion (Misc queries) | |||
Before today | Excel Discussion (Misc queries) | |||
IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
Today()-1 | Excel Discussion (Misc queries) | |||
=IF(OR(TODAY() |
Excel Discussion (Misc queries) |