|
|
#1
11-04-2015, 08:25 AM
|
|||
|
|||
Turn weekday number into weekday name
Excel gurus:
I found a function that returns a number from 1 to 7 representing a weekday. Is there a function that returns the name of the day instead? Or is there a function that turns the number into a weekday name? 
|
|
#2
11-04-2015, 10:46 AM
|
|||
|
|||
|
Hi
Hardcoded: =LOOKUP(WEEKDAY(A1,2),{1;2;3;4;5;6;7},{"Monday","T uesday","Wednesday","Thursday","Friday","Saturday" ,"Sunday"}) Or a better idea. Say in cells G1:G7 you have the numbers 1-7 & H1:H7 you have Monday-Sunday. =LOOKUP(WEEKDAY(A1,2),$G$1:$H$7)
|
|
#3
11-05-2015, 12:35 AM
|
||||
|
||||
|
If your week begins on Sunday then just Custom format your cell as "ddd"
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#4
11-05-2015, 08:14 AM
|
|||
|
|||
|
The custom formatting works great also. Thanks to both of you.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| counting "x" in a cell and sum the numbers in weekday | rayramirezdvm | Excel | 4 | 04-02-2015 02:58 PM |
 WEEKDAY Function with Conditional Formatting
|
meggenm | Excel | 1 | 08-09-2014 09:42 AM |
|
Recurring meeting on the 10th weekday of every month
|
cnwinger | Outlook | 3 | 06-19-2014 10:20 AM |
| NumberFormat: Capitalised Weekday Letters??? | tinfanide | Excel Programming | 3 | 04-17-2012 04:46 AM |
| My weekday function aint working | FraserKitchell | Excel | 12 | 05-25-2010 04:42 PM |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
