Have you ever had to work with a spreadsheet which contained a column full of dates, but you actually needed to see column full of the corresponding days of the week by name? Believe it or not, translating dates to the name of the day of the week is quite easy. Let’s say that we have the date 6/24/11 in cell A2. In order to find out what day of the week that day is, we can place this formula in another column on the same row:

Now in this new cell, you will see the value Friday. As you have probably already guessed, if the entire column is filled with dates, you can drag this formula down through the entire column.

Categories: BlogMicrosoft Office

Leave a Reply

Your email address will not be published. Required fields are marked *