The formula is an array formula that takes difference between corresponding values and then divides the difference with the values in the old column to get the percentages, later it averages (or sums) according to the requirement.
How to calculate difference between two dates
Calculate difference between two dates
Calculate months between two dates
Returns the average of its arguments
AVERAGE(number1, [number2], ...)
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM