COUPNCD Formula

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
JagwarmanAsked:
Who is Participating?
 
Jignesh TharConnect With a Mentor Senior ManagerCommented:
COUPNCD doesn't support monthly or semi-annually frequency.
0
 
JagwarmanAuthor Commented:
isn't 2 semi annually ?

so if COUPNCD doesn't support monthly is there a formula that does?
0
 
Jignesh TharSenior ManagerCommented:
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.
0
 
JagwarmanAuthor Commented:
ok tks
0
 
JagwarmanAuthor Commented:
thanks for the answer even it was not what I wanted to hear
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.