Aug 04 2020 12:40 PM
Aug 04 2020 01:15 PM
Aug 04 2020 01:19 PM
Aug 04 2020 02:46 PM
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.
Aug 04 2020 10:57 PM
@Moinjers , there are a couple of interpretations of your question, so I'll add mine. I'm assuming you have a range of dates and want to subtract two values if it's the first of the month. Assuming that the dates are in column B:
=IF(DAY(B2)=1,D2-C2,"")
Perhaps a more detailed explanation of what you are looking for will help to provide a precise solution.
Aug 04 2020 11:30 PM
Aug 04 2020 11:55 PM
Aug 05 2020 09:07 AM