Need help with a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help determining # of invoices 1
need help 1
Mapping strings to integers 5
what is the formula to find increment ? 3
Excel Excel Formula - IF Function with percentages 1
Invoices with Sales Order & Purchase Order 1
Getting Month to show on report 2
Need help with formula to forecast revenue 2

Back
Top