Suitable formula required to retun the no of days when spreading an available
value + receivables based on monthely budget limit from a chosen date to
remainder days of the months and reminder months of year so on.
The formula should work under the criteria of monthly budget value limit as
per the e.g below and no of days in the months, accounting start date and end
dates of the subsequent receivables values.

Month Limit Daily Avg. based on total month days
Sep-08 2900 96.67
Oct-08 3500 112.9
Nov-08 3200 106.67
Dec-08 2900 93.55
Jan-09 3000 96.77
Feb-09 3200 114.29
Mar-09 2900 93.55
Apr-09 3000 100
May-09 3200 103.23
Jun-09 2900 96.67
Jul-09 3000 96.77
Aug-09 3200 103.23

E. g. as on Date : 27-sep-2008 Days Spread

AvailableValue1 1200 4 days remaining from the date in Sep
ReceivableValue2 4800 46.46 days (=7.2 + 23.8 + 15.46 days) Not sure if I
am right

Hope excel will have some solution to this. Any help is highly appreciated.