Hi All,

I have workbook with two tabs, one is the contract list and the other one is prepaid, prepaid contains the list of invoices received for the contract with the start date and end date and amount.

if the invoice date is from 01-01-2013 to 30-06-2013 and the amount is 6000 the 6000 should distribute by month in the contract tab from Jan to June 1000 each.
If the second invoice received from 01-08-2013 to 31-12-2013 and the amount is 5000 then it should distribute from Aug to Dec 1000 each and July should be blank.
Basically I would like to identify the month the invoice not received or if we received more than the contract value.

If the start date is 15th of Jan then only 15 no of days portion should be distributed to Jan.

Any help appreciated.
Thanks
Jude