Forum Discussion
Excel
I want to sum x amount of months (no more than 12) usually 4- months at a time, subtract another cell of inventory levels, then use the current date to return a date of how long the inventory will last.
Either a return of Aug 8th, 2022....November 9th, 2023, etc.
or
1 month and a half, 4 months and 3/4s, etc.
I am currently using this formula,
=EDATE($A$2,12)-(SUM(M5:P5)-C5)
and I seem to be getting dates back to 2007 or forward till 2024, I can not figure out what is wrong with the formula
a$2$= current date, (12) is months
Sum is totalling 4 months worth of pending builds to be produced and (c5) is the current inventory level.
EDATE($A$2,12) is the date 1 year after today.
(SUM(M5:P5)-C5) subtracts the current inventory level from the sum of pending builds.
Does it make sense to subtract that directly from a date?
- HansVogelaar
Do you know of a better approach?
What I am after is having the ability for an automated return. I want to be able to take 4 months' worth of builds subtract out my current higher level of the build and then in return figure out that it will last only 1 month, 3 months and a half, 4 months and 3/4's, etc.You'll have to provide more information. How do builds and months and inventory relate to each other?
