EDATE - Excel and PowerPivot

Calculates the date a number of months before/after a start date

Type:   =EDATE(date,6) 

Calculates the date 6 months from the start date. To calculate prior dates use -(number of months).
For example, could be used to calculate a maturity a certain number of months from a start date.

Rounding - Excel

Rounding to decimal places

=ROUND(#,decimal places)

e.g. =ROUND (2750.21,0) = 2750

Rounding thousands, millions etc

e.g. =ROUND (2750.21,-3) = 3000

Rounding a number to the nearest desired multiple

=MROUND(24,5) = 25