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.
Calculating days elapsed between two dates or calculating days into the future is generally pretty straightforward in Excel. Counting dates elapsed is a simple subtraction. Equal the later date. The example here, B2 minus the earlier date. How many days have passed? The unit of time is one equal day. If we come up with an answer like this, simply format it. A couple of ways. Ctrl+Shift+Tilde is one way. You can also on the Home tab use the comma button if you wish.
This does introduce decimals however. You can hide those if you wish. So a couple of different ways to quickly format this. Of course, by double-clicking here we could copy these down the column. Here and there, we see sometimes we're within the same year. This crosses yearly boundaries with no difficulty whatsoever, and of course century boundaries as well. It's an accurate count to the day, how many days between these two days. Sometimes we need to look into the future. In the example here, we want to know 90 days from this date. That's the Review Date.
So, equal a given date plus 90, and we see the answer there. Double-click to copy these down the column. By the way, in this situation, if you did want to make sure that the review dates were working days, as these starting dates might have been. Let's assume that the starting dates are Mondays through Fridays. We'd be better off calling this a 91 days review, since that's exactly 13 weeks. That will change a little bit. So simply by editing these and making that be 91 we'd make sure that these are all within that Monday to Friday timeframe, if our start dates are within that frame as well.
So I make changes here. So that's a 91-day difference. Fast and easy to use in Excel.
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.