Viewers: in countries Watching now:
In Excel 2010: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2010. This course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios. Exercise files are included with the course.
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.
There are currently no FAQs about Excel 2010: Working with Dates and Times.
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.