Hi All,

I am racking my brain trying to work out a suitable formula to work out a flow on effect.

Situation is we supply funding to individuals for 12 month periods with varing start dates, our centralised funding is run on the financial year 1st July to 30 June.

What I need a formula to work out is if $10,000 funding is started on 15 January 2016 what pro rata amount will be spent in the 2015-2016 financial year and what amount will flow into the 2016-2017 financial year.

Thank you in advance for any help you can give me.

Cheers

Vanessa