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.

.