Days already on inventory

Hello Everyone,

This is my first time using the monday.com 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