tag:blogger.com,1999:blog-3794737577784583819.post1865728466167919172..comments2023-10-25T04:38:36.360-07:00Comments on Excel Enthusiasts: What Day Is It?Bob DeLaMartrehttp://www.blogger.com/profile/03761089085420930697noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3794737577784583819.post-86960100513625057912015-09-02T06:18:11.290-07:002015-09-02T06:18:11.290-07:00Hi,
I have a quick way to do it:
=INDEX({"Mo...Hi,<br /><br />I have a quick way to do it:<br />=INDEX({"Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday";"Sunday"};C7)<br /><br />You could also use a defined name to hold the weekday list to make the formula even shorter:<br />=INDEX(Days;1)<br />Use a define name <i>Days</i> with <br />{"Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday";"Sunday"}<br /><br />Cheers, ArchimedeusAnonymoushttps://www.blogger.com/profile/08605976111918747966noreply@blogger.com