Revenue Recognition

I need some help setting up a table that determines the revenue recognition schedule for orders. The table needs to provide the appropriate catch-up calculation if the Order Date is after the Start Date. I'm also having trouble with the calculations for partial months. If anyone has any ideas, some help would be great. Thanks.

The table appears as below as well as in an attachment:

Order Amount Order Date Start Date End Date Jun-07 Jul-07 Aug-07 Sep-07 Oct-07
Order 1 5,000 6/1/2007 6/1/2007 10/31/2007 1,000 1,000 1,000 1,000 1,000
Order 2 10,000 7/1/2007 6/1/2007 10/31/2007 4,000 2,000 2,000 2,000
Order 3 3,000 7/15/2007 7/15/2007 10/14/2007 500 1,000 1,000 500