Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct issues SteveDB1 Excel Worksheet Functions 25 June 3rd 09 04:58 PM
Need some comments on my Utility_Move class module. jchen Excel Worksheet Functions 0 August 21st 06 07:05 PM
Function to display day in text format Weasel Excel Worksheet Functions 2 February 13th 06 07:47 PM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 08:53 PM
in excel how to display results of a function and text in the sam. ez123 Excel Worksheet Functions 3 November 19th 04 02:16 PM


All times are GMT +1. The time now is 01:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"