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 ...

Formula of Mean: Know to How to Calculate Median for Grouped, Ungrouped data along with solved examples, questions with solution.

Formula of Median: Know to How to Calculate Median for Even, Odd Numbers along with questions with solution.