Start Excel and open the worksheet containing the number you want to round up. Click inside of the cell where you want to display the calculation. Type "=ROUNDUP ()" into the formula bar.

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