Hi,
I am working on a project where I have the closing balance for the week and have future consumption for the coming weeks. Now, I need to calculate for how many days will my inventory last based on my future consumption rate.
I have attached a sheet here for your refernce with the data. Please tell me how to apply a formulae that fits in this option.
Bookmarks