Extending COUPNCD for monthly payments

[llandes]

I'm new to VBA but not to programming. I need a function or method to calculate a next payment date for a bond based off the settlement date, maturity date, frequency, and basis. These are the same arguments for the COUPNCD function, but this function does not handle monthly payments.

Could someone please help!

[austenr]

Is this what you are looking for?
=COUPNCD(DATE(2008,1,25),DATE(2008,11,15),2,1)

will return 39583 (May 15, 2008). This is the first coupon date after the settlement date of January 25, 2008, where the maturity date is November 15, 2008, the coupon payments are semiannual and the actual number of days in the months and years are used in making the calculations.

[llandes]

No, i need to be able to handle monthly payments. i think i'll end up using an conditional saying if frequency = 12, roll the month forward 1.