In this Excel lesson you will teach yourself a lot about difference any kind in Excel.
Difference between two dates
The easiest way to calculate date difference is to use DATEDIF function. This is dedicated function to calculate difference between two dates.
=DATEDIF(B1,B2,”D”) – formula to calculate days between dates
=DATEDIF(B1,B2,”M”) – formula to calculate months between dates
=DATEDIF(B1,B2,”Y”) – formula to calculate years between dates
There is also a possibility to calculate quarters between dates.
To learn more we have also tutorial dedicated to date calculations.
Difference between two columns
You have two columns and would like to compare them. This is possible with Excel.
First thing you can check is if the cells are exactly the same. It is a Excel formula which easily spot the difference.
We used IF function to write the result down.
The second way is to check if the cell value exists in the other column. Vlookup function knowledge will help to build such Excel formula:
You can also compare columns for duplicates.
How do I compare time differences in Excel?
See the picture. I used simple Excel subtraction.
The trick is to change data formatting. Instead of doing it meanually I used TEXT function to do that. I will get the result as hours, minutes and seconds.
Please check laso time math tutorial.
To calculate the percentage difference you need to remember to subtract 1. Excel formula will be:
Subtracting 1 is needed to see the percentage difference.
More on how to calculate percent change in excel here.
Note that you can also use the ABS function to ensure that the result is always positive. For example, if you want to find the difference between the values in cell A1 and B1, and you want the result to always be positive, you can use the formula “=ABS(B1-A1)”.
Here you can find spreadsheet used in the lesson.