How to Autofill the Day of the Week in Your Spreadsheets

You’ve likely become at least familiar with the monotony of manually filling out a spreadsheet. Not only is it mind-numbingly boring, but it is also far too easy to make an error as you populate each and every cell with the data you need. This is increasingly true when you’re dealing with historical records that are apt to continue growing with time.

However, if you find yourself needing to populate a list of dates with the day of the week they fall on, there’s an easy way to accomplish this:

1. Make sure you have a list of your dates prepared. They can be sequential or not, just as long as they are all in one column. For this example, we’ll assume the dates are listed in column A.
   
   
2. Choose the column you want to use to list the day of the week. Here, we’ll assume you’re using column D. In cell D1, type in the following formula: =TEXT(A1,"dddd") This will give you the weekday that whatever date populates cell A1 was assigned.
   
   
3. Press Enter. The cell should immediately convert to the appropriate day of the week.
   
   
4. Click and drag the bottom-right corner of your formula cell down until all the cells with a corresponding date are covered.
   
   

It’s as simple as that!

For more great tips and tricks, return to our blog again soon.