BondAddMonth() function  Previous topicNext topicFirst topicLast topic


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

© 1995-98 Leap of Faith Research Inc.