You would need a macro to do this - a formula can only return a result
to the cell it is in.

Hope this helps.

Pete

On Sep 29, 6:40 pm, JJ wrote:
Hi,

Is it possible to put in a constant in column A, and Excel can equally
spread this constant based on the start & finish dates in column B and C to
column D and beyond?

How about have the constant spread into a S-curve or different curves? For
example, front end loaded early months or load up the later months?

Thanks.