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
 
Back
Top