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 either through VBA or directly as a
cell formula? Hope this makes sense.

Hi Brad,

You can do this without VBA. Check out the EDate
function that is included with the Analysis ToolPac addin.

Something like the following will get you the
=IF(YEAR($E9)=YEAR(Edate($E9,3)),1,0)

If the date is in E9, copy this formula to cells F9, G9,
and H9, then change the number 3 to 6 in G9 and to 9 in
H9. The 3 is the number of months from the date in E9.

Your result will be 1+F9+G9+H9

Best Regards,
Walt




-----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 either through VBA
or directly as a
cell formula? Hope this makes sense.


.