I need to allocate a specific value over a specific quarter based on the
date a user enters into Excel and the number of months the user wants
to allocate the value over. For example, if the user enters $300,000,
03/01/05 and 5 months into 3 independent data entry cells (A1,B1,C1
respectively) in a worksheet, I want the result to show up in Excel as:

Quarter 1 Quarter 2 Quarter 3
$60,000 $180,000 $60,000

Does anyone know of a formula that would accomplish this? I
appreciate your assistance.

Raymond