Help deduct a certain amount on a specific date

%3CLINGO-SUB%20id%3D%22lingo-sub-1565872%22%20slang%3D%22en-US%22%3EHelp%20deduct%20a%20certain%20amount%20on%20a%20specific%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565872%22%20slang%3D%22en-US%22%3EHey%20guys%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIm%20in%20a%20bit%20of%20a%20pickle!%20%3Apensive_face%3A%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20Im%20not%20bothering%20you%2C%20if%20this%20turns%20out%20to%20be%20an%20%E2%80%98easy%20fix%E2%80%99.%3CBR%20%2F%3EBut%2C%20I%E2%80%99ve%20been%20all%20over%20the%20web%20to%20find%20out%20how%20to%20make%20Excel%20deduct%20one%20value%20with%20another%20value%20on%20a%20specific%20day.%3CBR%20%2F%3E%3CBR%20%2F%3EE.g%3A%20Every%201st%20D2-C2%20and%20then%20show%20the%20remaining%20value%20in%20D2%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20it%20makes%20sense%2C%20I%E2%80%99ll%20be%20more%20than%20happy%20to%20try%20and%20elaborate%20on%20it%2C%20if%20Im%20talking%20jibberish%20%3Agrinning_face_with_sweat%3A%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1565872%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565929%22%20slang%3D%22de-DE%22%3ESubject%3A%20Help%20deduct%20a%20certain%20amount%20on%20a%20specific%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565929%22%20slang%3D%22de-DE%22%3EAdd%20or%20subtract%20dates%20in%20Excel%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fadd-or-subtract-dates-in-excel-for-mac-0ed1b935-200e-4307-b10e-f4fcca67f587%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fadd-or-subtract-dates-in-excel-for-mac-0ed1b935-200e-4307-b10e-f4fcca67f587%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Please%20have%20a%20look%20at%20this%20link%2C%20there%20you%20will%20find%20information%20about%20what%20you%20are%20looking%20for.%20%3CBR%20%2F%3E%20If%20this%20helps%20you%2C%20please%20mark%20it%20as%20correct%20answer%20so%20that%20others%20can%20get%20this%20info.%20If%20this%20answer%20does%20not%20solve%20your%20problem%2C%20please%20give%20us%20a%20short%20feedback.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20best%20regards%20%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565942%22%20slang%3D%22de-DE%22%3ERE%3A%20Help%20deduct%20a%20certain%20amount%20on%20a%20specific%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565942%22%20slang%3D%22de-DE%22%3EEven%20easier%20Formula%3A%20%3D%20A1-2%20A1%20%3D%20date%202%20%3D%20days%20I%20want%20to%20deduct%20It%20is%20the%20easiest%20and%20fastest%20solution.%20best%20regards%20Nikolino%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566081%22%20slang%3D%22en-US%22%3ERE%3A%20Help%20deduct%20a%20certain%20amount%20on%20a%20specific%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20understood%20the%20task%20by%20another%20way.%20Today%3C%2FP%3E%0A%3CP%3EIn%20cell%20D2%20we%20have%20value%201000%3C%2FP%3E%0A%3CP%3EIn%20cell%20C2%20we%20have%20value%20100%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20the%20first%20of%20each%20month%20we%20deduct%20C2%20from%20D2%20and%20put%20value%20into%20D2.%20Thus%3C%2FP%3E%0A%3CP%3EOn%2001%20Aug%20in%20D2%20shall%20be%20900%3C%2FP%3E%0A%3CP%3EOn%2001%20Sep%20in%20D2%20shall%20be%20800%3C%2FP%3E%0A%3CP%3Eetc%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20VBA%20programming%20but%20I%20don't%20understand%20the%20reason%2C%20that%20could%20be%20done%20by%20formulas%20with%20another%20data%20structuring.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566502%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20deduct%20a%20certain%20amount%20on%20a%20specific%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566502%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F749400%22%20target%3D%22_blank%22%3E%40Moinjers%3C%2FA%3E%26nbsp%3B%2C%20there%20are%20a%20couple%20of%20interpretations%20of%20your%20question%2C%20so%20I'll%20add%20mine.%20I'm%20assuming%20you%20have%20a%20range%20of%20dates%20and%20want%20to%20subtract%20two%20values%20if%20it's%20the%20first%20of%20the%20month.%20Assuming%20that%20the%20dates%20are%20in%20column%20B%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(DAY(B2)%3D1%2CD2-C2%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20a%20more%20detailed%20explanation%20of%20what%20you%20are%20looking%20for%20will%20help%20to%20provide%20a%20precise%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566561%22%20slang%3D%22de-DE%22%3ERE%3A%20Help%20deduct%20a%20certain%20amount%20on%20a%20specific%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566561%22%20slang%3D%22de-DE%22%3EHi%2C%20%3CBR%20%2F%3E%20In%20retrospect%20I%20understood%20it%20like%20this%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20This%20comes%20from%20writing%20quickly%20and%20thinking%20slowly%20or%20not%20%3CBR%20%2F%3E%20reading%20until%20the%20end.%20%3CBR%20%2F%3E%20acquired%20speed%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%20Fortunately%2C%20TheAntony%20gave%20a%20solution%20in%20this%20direction.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nicolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566613%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20deduct%20a%20certain%20amount%20on%20a%20specific%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566613%22%20slang%3D%22en-US%22%3EHey%20guys%2C%3CBR%20%2F%3E%3CBR%20%2F%3EFirst%20Off%2C%20thank%20you%20so%20much%20for%20your%20speedy%20reply!%20It%20means%20the%20world.%3CBR%20%2F%3E%3CBR%20%2F%3EWell%2C%20I%E2%80%99ve%20made%20a%20%E2%80%98list%E2%80%99%20of%20our%20monthly%20debt%20playbacks.%20They%E2%80%99re%20are%20always%20deducted%20the%20First%20in%20Every%20month.%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20I%E2%80%99ve%20made%20a%20collum%20for%20the%20amount%2C%20that%20We%20have%20to%20pay%20each%20month%20e.g%20C1%20And%20another%20that%20shows%20the%20remaining%20amount%20of%20the%20debt%20e.g%20D1%20-%20Instead%20of%20manually%20doing%20the%20typing%2C%20it%20would%20be%20amazing%2C%20if%20They%20are%20deducted%20automatically%20Every%20First%20of%20the%20month.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20maybe%20i%20need%20to%20make%20another%20collum%20E1%20for%20the%20remaining%20amount%3F%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20are%20your%20thoughts%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1567699%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20deduct%20a%20certain%20amount%20on%20a%20specific%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567699%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F749400%22%20target%3D%22_blank%22%3E%40Moinjers%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20594px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210436iB9CCB1D234577509%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EEntre%20the%20formula%20into%20C5%20and%20drag%20it%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
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 another value on a specific day.

E.g: Every 1st D2-C2 and then show the remaining value in D2

I hope it makes sense, I’ll be more than happy to try and elaborate on it, if Im talking jibberish

Best regards
7 Replies
Add or subtract dates in Excel
https://support.microsoft.com/en-gb/office/add-or-subtract-dates-in-excel-for-mac-0ed1b935-200e-4307...

Please have a look at this link, there you will find information about what you are looking for.
If this helps you, please mark it as correct answer so that others can get this info. If this answer does not solve your problem, please give us a short feedback.


best regards
Nikolino
I know I don't know anything (Socrates)
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)

@Nikolino 

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.

@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.

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)
Hey guys,

First Off, thank you so much for your speedy reply! It means the world.

Well, I’ve made a ‘list’ of our monthly debt playbacks. They’re are always deducted the First in Every month.

Then I’ve made a collum for the amount, that We have to pay each month e.g C1 And another that shows the remaining amount of the debt e.g D1 - Instead of manually doing the typing, it would be amazing, if They are deducted automatically Every First of the month.

But maybe i need to make another collum E1 for the remaining amount?

What are your thoughts?

@Moinjers 

That could be like this

image.png

Entre the formula into C5 and drag it down