today

  • Thread starter Thread starter stew
  • Start date Start date
S

stew

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

Best

Stew
 
=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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare texts in Excel 2003 2
date and time 1
Identifing Weeks in a Month. 3
formular discrepencies 4
help req on date 6
prob with TODAY() within a macro 2
Limit TODAY() to weekdays only 4
How do I format the date so that I have the name of the day abrevi 4

Back
Top