Forum Discussion
Help deduct a certain amount on a specific date
Hey guys, Im in a bit of a pickle! 😔 I hope Im not bothering you, if this turns out to be an ‘easy fix’. But, I’ve been all over the web to find out how to make Excel deduct one value with ano...
Even easier Formula: = A1-2 A1 = date 2 = days I want to deduct It is the easiest and fastest solution. best regards Nikolino I know I don't know anything (Socrates)
I understood the task by another way. Today
In cell D2 we have value 1000
In cell C2 we have value 100
On the first of each month we deduct C2 from D2 and put value into D2. Thus
On 01 Aug in D2 shall be 900
On 01 Sep in D2 shall be 800
etc
That's VBA programming but I don't understand the reason, that could be done by formulas with another data structuring.
- Hi,
In retrospect I understood it like this 🙂
This comes from writing quickly and thinking slowly or not reading until the end.
acquired speed 🙂
Fortunately, TheAntony gave a solution in this direction.
Nicolino
I know I don't know anything (Socrates)