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.