Days already on inventory

Hello Everyone,

This is my first time using the forum. Thank you all :slight_smile:

So, I am creating an inventory tracking board and I want to have one column display the number of days an specific item has been on inventory.

I tought of two ways to do it but could not get neither to work.

  1. If status = “On Inventory” , Today() - Date Adquiered
  2. If Date adquiered = “”, Today() - date acquired, date aquiered - date sold

things along these lines with the right openings and closings.

If anyone got an idea how i can do this, I would greatly appreciate it :slight_smile:
thank you

Hey @Ulises.Gomez, thanks for writing in, welcome to the community! :blush:

Have you already thought about using the DAYS function in the formula column? This will find the number of days between two dates. If you use the creation log column (the day you create the item), then that could be the day the item went on inventory.

The formula would then look like this to get the number of days between today and the creation log date:

DAYS(TODAY(),{Creation Log#Date})

What do you think? Would love to hear if this makes sense!