FUNCTION TO RETURN "DAY OF THE WEEK"
 

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?

FUNCTION TO RETURN "DAY OF THE WEEK"
 

=TODAY()

click format/cells/custom
Type: dddd


"Jo" wrote:

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?

FUNCTION TO RETURN "DAY OF THE WEEK"
 

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).


"Jo" wrote:

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?

FUNCTION TO RETURN "DAY OF THE WEEK"
 

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

On Mon, 3 Mar 2008 17:25:01 -0800, Jo wrote:

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?

FUNCTION TO RETURN "DAY OF THE WEEK"
 

SPOT ON - thanks

"JMB" wrote:

=TODAY()

click format/cells/custom
Type: dddd


"Jo" wrote:

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?

FUNCTION TO RETURN "DAY OF THE WEEK"
 

quite welcome - thanks for the feedback

"Jo" wrote:

SPOT ON - thanks

"JMB" wrote:

=TODAY()

click format/cells/custom
Type: dddd


"Jo" wrote:

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?