How to List Day Names in Excel without Dates
See Microsoft Excel: Tips and Tricks for similar articles.
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?
Here's what I'm going for, again, without the fields containing actual dates:
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?
