ExcelBanter - today

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - today (https://www.excelbanter.com/excel-discussion-misc-queries/203171-today.html)

SteW

today

=today() gives me todays date. What if anything would give me todays weekday
i.e Monday Tuesday etc

Best

Stew

~slacker~

today

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

Sandy Mann

today

=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

dennis

today

=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

SteW

today

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

All times are GMT +1. The time now is 01:39 PM.