Formula to track the age of inventory

[ryan_o]

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.

 

[ttdk1]

=DATEDIF(IF(C3,H3,TODAY()),TODAY(),"d")

 

[ryan_o]

Thank you for the quick response. It seems like it works but whenever I drop the inventory to 0 it also changes the days aged to 0. Is there a way that when I change the quantity to 0 that it just stops on the days aged at that point and doesn't continue to count?

 

[ttdk1]

Yes, but to do so would require VBA.

 

[ryan_o]

That sounds above my head. I will just delete the formula in the cell and manually put the last day in. Thank you for the responses.