| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate date when funds run out based on current usage
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!!! =) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
