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