Spreading value across date range

[mdrew9]

Looking for a way to spread a value across a dynamic range of dates. So I have a schedule start date and a finish date and I want to spread a value across that automatically. The range and value will change.

 

[Zakkaroo]

Looking for a way to spread a value across a dynamic range of dates. So I have a schedule start date and a finish date and I want to spread a value across that automatically. The range and value will change.

Im not sure I understand. This is what I THINK you mean.

Lets say the value is 10. The start date is the 15th March, End date is 20th March (5 days). Spreading 10 over 5 days gives you 2 per day?

If that is what you mean then assuming that:

A1 = Start Date
B1 = Completion Date
C1 = 'Value' that you want spread evenly across the range
D1 = C1/(DATEDIF(A1,B1,"d"))

Make sure to format D1 as a number not a date
[Edit] Meant D1 not C1 in the last sentence

 

[mdrew9]

Im not sure I understand. This is what I THINK you mean.

Lets say the value is 10. The start date is the 15th March, End date is 20th March (5 days). Spreading 10 over 5 days gives you 2 per day?

If that is what you mean then assuming that:

A1 = Start Date
B1 = Completion Date
C1 = 'Value' that you want spread evenly across the range
D1 = C1/(DATEDIF(A1,B1,"d"))

Make sure to format D1 as a number not a date
[Edit] Meant D1 not C1 in the last sentence

You almost had it except this formula would need to be applied from March 1 to March 20th, and in March 1 - 14th there would be no value put there.