Guys! i want a simple formula to calculate months of stocks cover for my inventory. I have an opening stock and sales forecast for the next six months.
thanks
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Months of Stock Cover
0
Post Edited
Title Not Appropriate: Title was not appropriate. (could be all caps, annoying punctuation, etc.)
Discussion
Attach your worksheet to the question so that we can see what kind of data you have and where. Explain the method by which you wish to calculate the reach and show a sample result in your worksheet.
Variatus (rep: 4889) Dec 21, '17 at 7:06 am