Archive of Mr Excel Message Board

We need a formula that will split a check amount that is equal to or more than $1000. This formula would take into consideration the daily rate and days paid of an individual and divide up the entire pay period into smaller periods so that the entire amount of the check if it is equal to or greater than $1000 is paid out in smaller increments adding up to the total amount and showing the breakdown by pay periods. For example: If the amount of the check is $1205.72 and the daily rate is $76.80, and the total pay period covers 11/2/01 - 11/24/01 the formula could break this amount down into equal portions such as... 11/2/01 - 11/21/01 (the$); 11/20/01 - 11/24/01 (the$). Please help.