View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Narnimar Narnimar is offline
external usenet poster
 
Posts: 132
Default Calculate date when funds run out based on current usage

Hi,
I have a list of monthly budget amount, fund amont as on a day and some
incomining funds . Question1. What is the formula for calculating the
elapsed number of days to return
in c1 for a budget value of a month which is in a cell a1 and a given date
in b1 and available fund in d1. In an instance, for Sept 2008 and Oct 2008
the Budget reserved as 2900 and 3500. If available fund is 1200 on 27 sept
2008 the fund will last 4 days (as per day Avg. for sept is 96.67) + 7.2 days
in Oct (at Oct Avg of 112.90) I need to return Answer as 11.2 days
Question2. What is the formula for calculating the spread number of days for
an available fund in d2 to return
in c2 for its next following month budget which is in a cell a2 where the
day calculation to be
continued from the c1. The Budget amount for October 2008 will be 3500, the
Available fund 6000. The same like above the formula required is the total no
of days but continued from the above resulted day (which ends on 8th Oct
2008). Kindly hepl.