Calculate Dates in Excel 2007 or 2010 Workbooks the Easy Way

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:

=DATEDIF(A2,B2,"d")

 

What we did is used the DATEDIFF function to calculate the number of days.

Calculate Dates in Excel

You can also use the (-) operator like this =B2-A2 like below:

Calculate Dates in Excel -2

Another way of doing it is using the NETWORKDAYS function. NETWORKDAYS function will find all weekdays between the two dates:

Calculate Dates in Excel -3

Find Weeks Between Dates in Excel 2010

The easiest why to do this is by using the INT function:

IT will look like this:

=INT((B2-A2)/7)

 

Excel How to

Find Months Between Dates in Excel 2010

Here is how you do this using the DATEDIFF function:

=DATEDIF(A2,B2,"m")

 

Here is what it will look like:

Excel How to -2

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:

=DATEDIF(A2,B2,"y")

 

Excel how to -3

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.

Follow me

Ryan Dozier

Just your typical neighborhood geek that loves computers and finding awesome free stuff.
Follow me