Split a value across FY's based on start and end dates

[hindk]

I'm trying to determine the impact of hardware/software maintenance agreements on each financial year.

Eg.
Start date 1 May 2011
End date 30 June 2013
Total Value $850,000

I need to know the impact for 2010/11, 2011/12 & 2012/13 to help with budget development for future years.

I've tried taking it down to a daily cost and then multiplying it out but this still requires some work as each item has a different start and end date.

If anyone has a suggestion for formulas it would be greatly appreciated.

Thanks.

 

[skippy099]

Nice one ! thanks for this

 

[skippy099]

Ah No, I tried your formula for a monthly split but it doesn't add up at the end.

With the same example but changing F1:J1 to 01/01/2014, 02/01/2014, 03/01/2014... and so on.
If someone could give a solution for this that would be so helpful and greatly appreciated.

Thanks