The midpoint formula seems much more complicated, but when used in a price-demand calculation, allows for the same coefficient of elasticity regardless of whether the price is going up or going down.

Since each date is really just a number stored in Excel, to compute the midpoint of two dates you would use the same mathematical formulas you would use to calculate the midpoint of two numbers ...