Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula required for elapsed days for fund estimation
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). Anyone has answer? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula required for elapsed days for fund estimation
Requirement not clear. Can you paste sample data?
Also if A1 and B1 have dates then if you put =B1-A1 in C1, you will get the difference in days between the two dates... "Narnimar" wrote: 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). Anyone has answer? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula required for # of days Calculation | Excel Discussion (Misc queries) | |||
Calculating elapsed days and hours | Excel Discussion (Misc queries) | |||
Please Help With Days Elapsed And Days Remaining Calculation | Excel Worksheet Functions | |||
formula for tracking number of elapsed days from a stard date | Excel Worksheet Functions | |||
Elapsed time in days | Excel Worksheet Functions |