I apologize if I missed threads that discuss this, but I'm trying to calculate the estimated end/depletion date of available money based on current rate of spend.
Here's the scenario (per example screenshot):
Column C has a list of PO's.
Column D-O shows amount of money spent against each PO in a given month (again, just an example)
Column P shows the remaining amount of each PO.
Column Q is what I'm trying to figure out.
I need to figure out the formula that calculates the estimated date Column P for each PO will reach zero.
Any help would be much appreciated!
Here's the scenario (per example screenshot):
Column C has a list of PO's.
Column D-O shows amount of money spent against each PO in a given month (again, just an example)
Column P shows the remaining amount of each PO.
Column Q is what I'm trying to figure out.
I need to figure out the formula that calculates the estimated date Column P for each PO will reach zero.
Any help would be much appreciated!