I have searched the net but haven't been able to find the formula I am looking for. I have a spreadsheet where I have the amount of inventory in column C and the date purchased in column H. I am trying to come up with a column to automatically count the age of the product from the purchase date. I would like the age to keep counting as longs as the quantity in column C is greater than 0.
So far in the age column I have =DATEDIF(H3,TODAY(),"d") which is properly counting how many days it has aged. But I need the age to stop once I adjust the inventory to 0.
So far in the age column I have =DATEDIF(H3,TODAY(),"d") which is properly counting how many days it has aged. But I need the age to stop once I adjust the inventory to 0.