Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help determining # of invoices
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. |
#2
|
|||
|
|||
This should get you close
If A1 is date the contract starts and A2 the date it ends =ROUNDUP((MONTH(A2)-MONTH(A1))/3,0)+1 Shortcoming is if start date is early in the month and end date is late in that month, you might get slightly more than 90 days between billings. Need a more indepth formula that includes days if you're worried about getting an early June bill out for a job that starts early March and ends late June, for example. -----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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables - "simple" question | Excel Discussion (Misc queries) | |||
create invoices | New Users to Excel | |||
Invoices | Setting up and Configuration of Excel | |||
Create invoices from excel workbook | Excel Worksheet Functions | |||
How to print invoices for each advertiser from Excel worksheet | Excel Worksheet Functions |