Excel will typically display your dates so that you are viewing them as month/day/year (or day/month/year in many countries outside the United States), but it may be more useful for you to see those dates as days of the week instead. Fortunately you can use a custom formatting selection to view your dates in this manner.
Formatting Dates in Excel 2010 as Days of the Week
The steps in this guide will show you how to change the format on a cell containing a date (for example, 10/11/2015) so that it shows the day of the week instead (Sunday). The value of the cell will still be the date, but the visible text will be the day of the week that the particular date fell on.
When completed successfully, the data in your cells should look similar to that below.
Is there a lot of formatting applied to a spreadsheet, and you would prefer to remove all of it at once, rather than trying to change each individual format setting? You can clear all cell formatting in Excel 2010 to start fresh with the data in your worksheet. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
