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

The median is the middle number in a sorted ascending or descending list. It can be more descriptive of the dataset than the average. It’s quite different from the mean.

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

Formula of Mode: Know to How to Calculate Median for Grouped, Ungrouped Numbers along with questions with solution.