WEEKDAY() function: display TEXT not numeric weekday
 

The Weekday() function can display the numeric value of the day of the week.
I've done this. Now, I'd like to display 1=Sun; 2=Mon etc. Without going
through a nested IF(A5=1,"Sun",if(A5=2,"Mon",....)))))) etc. is there a
function that I'm missing here that's MUCH simpler?
Suggestions appreciated!!!
Tia,
Tom

WEEKDAY() function: display TEXT not numeric weekday
 

How about just looking at the whole date:

=text(a1,"ddd")



Tom wrote:

The Weekday() function can display the numeric value of the day of the week.
I've done this. Now, I'd like to display 1=Sun; 2=Mon etc. Without going
through a nested IF(A5=1,"Sun",if(A5=2,"Mon",....)))))) etc. is there a
function that I'm missing here that's MUCH simpler?
Suggestions appreciated!!!
Tia,
Tom

--

Dave Peterson

WEEKDAY() function: display TEXT not numeric weekday
 

Hi,

What if we change the format of the cell to Customer - dddd

I think that would give the weekday.

regards,
Sajen


"Dave Peterson" wrote:

How about just looking at the whole date:

=text(a1,"ddd")



Tom wrote:

The Weekday() function can display the numeric value of the day of the week.
I've done this. Now, I'd like to display 1=Sun; 2=Mon etc. Without going
through a nested IF(A5=1,"Sun",if(A5=2,"Mon",....)))))) etc. is there a
function that I'm missing here that's MUCH simpler?
Suggestions appreciated!!!
Tia,
Tom

--

Dave Peterson

WEEKDAY() function: display TEXT not numeric weekday
 

Hi Tom
You could just use =A5 and FormatCellsCustom ddd

--
Regards

Roger Govier


"Tom" wrote in message
...
The Weekday() function can display the numeric value of the day of the
week.
I've done this. Now, I'd like to display 1=Sun; 2=Mon etc. Without
going
through a nested IF(A5=1,"Sun",if(A5=2,"Mon",....)))))) etc. is there
a
function that I'm missing here that's MUCH simpler?
Suggestions appreciated!!!
Tia,
Tom