How to List Day Names in Excel without Dates

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: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:


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

Anybody have a better solution?

Author: Nat Dunn

Nat Dunn is the founder of Webucator (, a company that has provided training for tens of thousands of students from thousands of organizations. Nat started the company in 2003 to combine his passion for technical training with his business expertise, and to help companies benefit from both. His previous experience was in sales, business and technical training, and management. Nat has an MBA from Harvard Business School and a BA in International Relations from Pomona College.

Follow Nat on Twitter at @natdunn and Webucator at @webucator.

About Webucator

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, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Check out our complete course catalog.