Thread: [Solved] Turn weekday number into weekday name
View Single Post
 
Old 11-04-2015, 10:46 AM
Kevin@Radstock Kevin@Radstock is offline Windows 8 Office 2013
Office 365
  
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default
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)
Reply With Quote