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

You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

Add Numbers in Excel Performing addition in Excel is fairly straightforward. You can either add numbers directly or use cell references to work with values stored in specific cells.