BondAddMonth() function

BondAddMonth()

BondAddMonth(argument list…)

This function is similar to AddMonth, but is specialized to the bond market. The difference is that BondAddMonth will return a date corresponding to the end of the month if the base date in the end of the month (i.e. the so called "end-of-month" rule). For example, if Base_Date is February 28 in a non-leap year, and the Time_in_months is 6, BondAddMonth will return August 31, whereas AddMonth would return August 28. The function uses the following arguments:

Argument	Description	Restrictions
Base_Date	starting date	valid Excel date number
Time_in_months	months to add to Base_Date	integer value