Join Dennis Taylor for an in-depth discussion in this video WEEKDAY: Day-of-week determination, part of Excel 2013: Working with Dates and Times.
Knowing the day of the week of a date can be really valuable information. Think of sales, think of transactions, think of orders, think of delivery dates, that sort of thing. We need to know what day of the week and in this worksheet called weekday, we'll be using a function by that very name, weekday. What day of the week did these sales occur on? Equal weekday, left parenthesis in this case A 2, enter a 2. 2 means day of the week 2 is Monday, 1 is Sunday, 3 is Tuesday, 4 is Wednesday and so on, and so on.
But the answer would be a lot more viable if we could actually see the Monday right here. So any time you use the weekday function, what you need to do, is simply to go to format cells. You can do it quickly with control 1, and there, on the number tab, choose custom, and provide either, a custom format of 3 d's to abbreviate the day, Mon or 4 d's to spell it out. For example, in this case, Monday, looks like that. And if we want to copy this function down the column, we'll simply double click the lower right hand corner.
And we have the day of the week. So in all cases here we're using the week day function. I think most people in using this will want to change it by way of format or custom format. I used 4 ds, possible use three ds to get the abbreviation. Valuable information and analyzing any number of different kinds of data in Excel
- Describe the default settings Excel has in place for dates and times.
- Identify keystroke shortcuts to insert dates and times into a cell.
- Explain how to create a custom date format.
- Recognize the functions used to calculate time intervals that include restrictions.
- Recall the keystroke shortcut to apply a general format that reveals the real information in a cell.
- Define the purpose of the Text to Column tool.