Here is the case - StartDate EndDate Total amount January February March ...... 01/27/2007 06/30/2007 $1,875.00 01/01/2007 08/07/2007 $2,195.00 02/10/2007 05/01/2007 $1,500.00 How to calculate amounts for each month ?