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?