Sometimes when using Excel 2010 you have a variety of dates that you need to compare and find out how many days, weeks, months or years between them. Here is how to calculate dates in Excel 2010 and 2007 as well.
Calculate Dates in Excel
Calculating dates in Excel is very easy to do and isn’t really that hard. Here are a couple of ways to manipulate your dates to get the most out of them. If you need help with Excel in general you can always go to Microsoft Excel help and how-to site.
Find Days Between Dates in Excel 2010
So lets get started. Open Excel and enter some dates into column A and B. In Column C we will enter the formula below:
What we did is used the DATEDIFF function to calculate the number of days.
You can also use the (-) operator like this =B2-A2 like below:
Another way of doing it is using the NETWORKDAYS function. NETWORKDAYS function will find all weekdays between the two dates:
Find Weeks Between Dates in Excel 2010
The easiest why to do this is by using the INT function:
IT will look like this:
Find Months Between Dates in Excel 2010
Here is how you do this using the DATEDIFF function:
Here is what it will look like:
Find Years Between Dates in Excel 2010
Using the DATEDIFF function again we can find the years between the two dates:
Here is what it looks like:
That is it you now you can officially calculate dates in Excel with your eyes closed. Well maybe.
Nonetheless, like we said before this is a brief look at what you can do with dates in Excel. You can also use these formulas in Excel 2007 as well as 2010. Want more Excel how to don’t forget to check out our other Excel post.
Excel isn’t the only Microsoft Office product we have skills in check out our other Office 2010 how to articles or leave a comment in the comment section below for more help.
Latest posts by Ryan Dozier (see all)
- How to Disable Notifications with Do Not Disturb in Mac OS X - March 9, 2014
- How to Setup Time Machine on Mac OS X - March 7, 2014
- Boot Straight into the Desktop in Windows 8.1 - February 16, 2014