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.
- View Offline
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
- Understanding how Excel records and stores dates and times
- Looking at standard date and time entry options and acceptable alternatives
- Using the TODAY and NOW functions
- Customizing date formats
- Using keyboard shortcuts
- Formatting time for hours over 24
- Calculating differences across dates and times
- Calculating the day of the week
- Working with holidays
- Validating dates
- Converting formatted dates to usable data