Date function

9

918

I have a construction schedule with the budget to be drawn out over time. My
cells are set up as follows:

# of Months Start Month End Month Amount Jan-06 Feb-06
March 06
3 1/01/06 3/31/06 $100,000

How do I create a function so that when someone inputs in the number of
months and start and end months, the appropriate amount is allocated over the
necessary months? Thanks.
 
C

CLR

Assuming months in A2 and TotalAmount in D2.....put this formula in each
month in row 2, and copy down as appropriate.......

=$D2/$A2

Vaya con Dios,
Chuck, CABGx3
 
Top