Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
It's not always an obvious thing to do, but being able to determine day of the week for a given date could be some good valuable information. For example, you've recorded some sales here on different dates in the first part of 2010. You're a little bit curious as to how the operation works. You've had some ups and downs with your sales force. You're trying to figure out which day of the week these particular sales occurred on. So on Cell B2 here, we're simply going to enter the formula =WEEKDAY. Now you can by formatting have the day of the week actually appear in Column A, but sometimes you really want to isolate this information in a separate column in adjacent cells.
So the WEEKDAY of this particular sales date is 6. Six? The numbering scheme is 1 is Sunday, 2 is Monday etcetera, therefore 6 is Friday. You can certainly live with this, and I will double-click to copy down the column kind of quickly. But I think for many of us we would like to see the day of the week actually spelled out or at least abbreviated. So in case, press Ctrl+1 or right-click, Format Cells. And jump immediately into the Custom category on the Number tab.
And click in the panel where it says General and type in either 3 d's if you a 3 letter abbreviation of the day of the week or four 4's for a full spelling. And there we see the entries this way. I think most will prefer to make the change this way. Now there's an alternate setting in there too, if you wish to have the numbers be 0-6. I can't think of a good reason for doing that exactly, but that's another possibility too. But for many people this is an enlightening feature that they just did know that the capability existed. And it does make sense here and there to analyze your data based on the information about the day of the week.
Use the WEEKDAY function.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 73620 Viewers
80 Video lessons · 129297 Viewers
52 Video lessons · 63666 Viewers
59 Video lessons · 49428 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.