Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 76663 Viewers
80 Video lessons · 130859 Viewers
52 Video lessons · 64761 Viewers
59 Video lessons · 50586 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.