Re: Subtract a set value from a cell on a specific day and replace cell value
I am very sorry for the Confusion. Cell A1 has 1000 entered into it. Cell B1 was where I was entering the formula.
And yes, I see what you are saying about Cell A1 has to remain a constant since it was manually entered. I will re-evaluate what it is that I am trying to accomplish and find a more precise way of asking it.
Thank you for pointing out my flaw. I apreciate it.