Need help with a formula
 

Hello,

I am trying to create a spreadsheet that will determine the # of invoices
for a contract that will happen in 2005. Primarily will be, how many invoices
will happen in quarterly installments. This is easy if you have say a 12
month contract starting in January. There will be 4 invoices, an invoice
occuring on Jan, April, July and October. But now say the contract starts in
April and it is a 7 month contract. An invoice will occur in April, July and
October. So only 3 invoices will occur. Is there any way to set this up in
Excel to automatically calculate this? Hope this makes sense.

What is your "date" format that you want the formula to
determine invoice counts?


-----Original Message-----
Hello,

I am trying to create a spreadsheet that will determine
the # of invoices
for a contract that will happen in 2005. Primarily will
be, how many invoices
will happen in quarterly installments. This is easy if
you have say a 12
month contract starting in January. There will be 4
invoices, an invoice
occuring on Jan, April, July and October. But now say the
contract starts in
April and it is a 7 month contract. An invoice will occur
in April, July and
October. So only 3 invoices will occur. Is there any way
to set this up in
Excel to automatically calculate this? Hope this makes
sense.

.