3 Calculate the absolute difference between two numbers in Excel Using ABS function The percentage difference between the two numbers in Excel. DATE2015 5 20 - DATE2015 5 15 Wrapping up when it comes to subtracting dates in Excel and you want to find out how many days are between two dates it makes sense to go with the easiest and most obvious option - simply subtract one date directly from another. Forgot username or password.
To find the percentage difference in excel first find the difference between the two numbers and divide this difference with base value.
Because this could result in a negative time if the local time is far east and is early in the morning the formula uses an IF statement adding a 1 if the result would be negative. This means 1 hour 124 0041666667. Remember that the differential in hours must be converted to a decimal first by dividing by 24. Then type a formula like one of the following.