Forum Discussion
LearningFurther
Jul 25, 2022Copper Contributor
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 la...
HansVogelaar
Jul 25, 2022MVP
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?