Hello, Excel masters
I've just joined this forum hoping I can find the answer to a small problem I'm facing and I humbly ask for your ideas to solve it.
I have tried to find the same problem in previous posts, but there are so many of them and time is not on my side.
The attached example shows a basic material requirements/planning sheet, in which:
- column A: Date when the quantity is planned to enter or exit the warehouse
- column B: The quantity planned to enter/exit the warehouse
- column C: The balance quantity
I wonder if there is a way (standard Excel formulas or VBA macro) to show in column D the date when the negatives will be fulfilled (either in the past or in the future). I have calculated manually the dates in column E, but I cannot replicate the logic with formulas.
I use Office 365 on regular basis but on the lower level of difficulty.
Please let me know if there is any other info I need to provide.
Thank you,
Alin
Bookmarks