FUNCTION TO RETURN "DAY OF THE WEEK"

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

I want a function to return the day of the week in text not integer (ie
"Tuesday"). I've tried the TODAY and WEEKDAY functions but must be doing
something wrong. Can you help?
 
or you could use:

=TEXT(TODAY(), "dddd")

your choice depends on whether you want the contents of the cell to be text
or numeric (my first suggestion).
 
3/3/2008 in A1

In B1 enter =WEEKDAY(A1) will return the number 2

Format as Custom dddd to see Monday


Gord Dibben MS Excel MVP
 
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

WEEKDAY 7
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Showing date as day of week 4
Sequence of Weeks in a month 8
Excel Table Help 2
How to format cell to get first capital letter? 5
how to Show dates as the day of the week? 2
Calculate End Date Using Start Date and No. of Days excluding specific days. 0

Back
Top