functions COUPNCD in VBA

[mfuada]

Hi guys
Need ur help...I want use Excel worksheet functions COUPNCD in my VBA code for Access.. do i have to elaborate the function into mathematical operation? cos i didn't find any function in access equivalent with that function....
thanks...

 

[Guus2005]

Could you describe what COUPNCD does?

 

[mfuada]

This is what COUPNCD does, it's a semi-annual coupon bond pricing, It determines the next coupon/interest date after the settlement date. If the maturity date is 15-Jul-08 and the coupon is paid semi-annually, then the coupon dates are 15-Jan and 15-Jul (6 month difference) ignoring the year. If the settlement date is 16-Oct-07, then the next date after 16-Oct-07 between 15-Jul and 15-Jan should be 15-Jan-08. that's pretty much how the COUPNCD works in excel...
and i have a dead end with my work trying to figure this thing out...

 

[Guus2005]

You must create a function which does the same. I think that you can copy it from Excel VBA to Access VBA with some slight modifications.

Post the code if you need more help.

HTH