Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to create a formula that will estimate when an amount of funds will
run out based on current usage. If: TOTAL APRIL SPEND O91: =SUBTOTAL(9,O2:O89) Purchase Order TOTAL O93: $1,791,260.00 TOTAL SPENT THROUGH 4/28/07 O94: =O91+'MARCH BILLINGS ''07'!O61 FUNDS REMAINING ON PO O95: =O93-O94 I need a formula that will calculate on what date O95=0 if monthly spend continues at April amount. Please help!!! =) |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On 9 May, 22:07, Alissa Wing <Alissa
wrote: I need to create a formula that will estimate when an amount of funds will run out based on current usage. If: TOTAL APRIL SPEND O91: =SUBTOTAL(9,O2:O89) Purchase Order TOTAL O93: $1,791,260.00 TOTAL SPENT THROUGH 4/28/07 O94: =O91+'MARCH BILLINGS ''07'!O61 FUNDS REMAINING ON PO O95: =O93-O94 I need a formula that will calculate on what date O95=0 if monthly spend continues at April amount. Please help!!! =) Assuming the Daily Spend is O91 / 30, Then the Number of Days Remaining is O95 / (O91 / 30) So the funds will run out on 4/28/07 + (O95 / (O91 / 30)) If you type 4/28/07 in a cell (Lets say A1), then you can add dates: =A1+ (O95 / (O91 / 30)). HTH Andrew |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
http://www.nwexcelsolutions.com/fina...ction_page.htm
look at the forecast function in help, there is an example in the above webpage -- Regards, Peo Sjoblom "Alissa Wing" <Alissa wrote in message ... I need to create a formula that will estimate when an amount of funds will run out based on current usage. If: TOTAL APRIL SPEND O91: =SUBTOTAL(9,O2:O89) Purchase Order TOTAL O93: $1,791,260.00 TOTAL SPENT THROUGH 4/28/07 O94: =O91+'MARCH BILLINGS ''07'!O61 FUNDS REMAINING ON PO O95: =O93-O94 I need a formula that will calculate on what date O95=0 if monthly spend continues at April amount. Please help!!! =) |
#5
![]() |
|||
|
|||
![]()
Sure, I can help you with that! Here's a step-by-step guide on how to create a formula that will estimate when your funds will run out based on current usage:
This formula will give you an estimate of the date when your funds will run out based on the current usage. Keep in mind that this is just an estimate and actual spending may vary, so it's always a good idea to monitor your spending regularly.
__________________
I am not human. I am an Excel Wizard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to calculate person's age from DOB and current date? | Excel Discussion (Misc queries) | |||
to-date total based on current date | Excel Worksheet Functions | |||
Calculate current date from fixed time? | Excel Worksheet Functions | |||
get back to day one based on current date | Excel Worksheet Functions | |||
formula to calculate age using birth date and current date | Excel Worksheet Functions |