View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default 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