Oct 03 2022 09:47 PM
Hello All
I'm working as a professional inventory planner in one of FMCG companies in Pakistan. I'm stuck with one formula in which i have to calculate the date Manually.
Scenario:
Like i have to check where my inhand inventory will finish then i will enter manually1 day before finishing my stock in the date column. Is there any formula to calculate automatically? Thanks in advance
Anas Ejaaz
email address removed for privacy reasons
Oct 04 2022 03:23 AM
How should the date be calculated?
Oct 04 2022 11:00 AM
I did manually.. i go back in my chart and see where the inventory will go low. Then less one day from there to backward
Oct 04 2022 11:05 AM
I'm afraid that's too vague.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.