<div>
isn't 2 semi annually ?<br />
<br />
so if COUPNCD doesn't support monthly is there a formula that does?
</div>


isn't 2 semi annually ?

so if COUPNCD doesn't support monthly is there a formula that does?

<div>
sorry..Yes 2 is semi-annually. I meant to say that COUPNCD doesn't support monthly (12) or bi-monthly (6).<br />
<br />
Let me check if custom VBA can support this.
</div>


sorry..Yes 2 is semi-annually. I meant to say that COUPNCD doesn't support monthly (12) or bi-monthly (6).

Let me check if custom VBA can support this.

<div>
thanks for the answer even it was not what I wanted to hear
</div>


thanks for the answer even it was not what I wanted to hear

<div>
<div class="content wysiwyg-content">
Hi I am using the below formula which works fine when the frequency is 1, 2 or 4 but, I have been asked if it's possible to include 12 which the formula does not work with. So my question is, is there a formula that will include a monthly frequency<br />
in addition to Quarterly, Semi Annually and Annually <br />
<br />
=COUPNCD(TODAY(),H7,G7,3)<br />
<br />
Thanks
</div>
</div>


Hi I am using the below formula which works fine when the frequency is 1, 2 or 4 but, I have been asked if it's possible to include 12 which the formula does not work with. So my question is, is there a formula that will include a monthly frequency
in addition to Quarterly, Semi Annually and Annually 

=COUPNCD(TODAY(),H7,G7,3)

Thanks

COUPNCD Formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.