How to List Day Names in Excel without Dates

  • google plus

In Brief...

In Excel, you can use the TEXT() function to output the day name from a date. For example, if cell A1 contains 12/18/2017, you can output "Monday" in another cell using TEXT(A1,"dddd"). But I needed a way to list 10 day names in a row without any associated dates. And I wanted the list to update based on the value in the first cell. So, how do you do that?

Take our Intermediate Microsoft Excel 2016 Training course for free.

See the Course Outline and Register

Instructions

Here's what I'm going for, again, without the fields containing actual dates:Excel Day List

Cell A1 contains the text "Tuesday". Cells A2 through A10 contain a function that makes them update based on the value of A1.

The only solution I could think to come up with was to use Excel's IF() function with a whole lot of nesting, like this:

=IF(A1="Sunday","Monday",IF(A1="Monday","Tuesday",IF(A1="Tuesday","Wednesday",IF(A1="Wednesday","Thursday",IF(A1="Thursday","Friday",IF(A1="Friday","Saturday",IF(A1="Saturday","Sunday","Error")))))))

It does the trick, but it's not pretty.

Anybody have a better solution?

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, XML, Windows, Java, Adobe, HTML5, JavaScript, Angular, and much more. Check out our complete course catalog.

Categories

Courses

Author: Nat Dunn

Nat Dunn founded Webucator in 2003 to combine his passion for web development with his business expertise and to help companies benefit from both.

Discuss