Hello all,
We utilize Libre for our entire inventory of small parts. Since taking over the Warehouse Manager position I have been trying to enhance our productivity by adding usage to our current spread sheet. With that said, I have been searching for a formula that will calculate usage based on number of items used, date and aging by date. Not an easy formula for me to figure out so I am reaching out for some help. Below is what I have and what I need. If this can’t be done with just one column than maybe a few.
CELL - B8 IS QTY ON HAND
CELL - B4 = TODAY()
CELL - E2 - DATE OF INITIAL INPUT OF THE INVENTORY
CELL - H8 - THE CELL I AM LOOKING TO HAVE THIS FORMULA.
Now if there is a Calc template for inventory that already has this information including conditional formatting Awesome! Just need the link. But if not, can anyone provide a formula to try.
Thank you,
Jason