I'm working on an inventory management spreadsheet that was posted in another thread, which unfortunately I don't have the link to anymore. It has two sheets, a master inventory list and an equipment use log, and currently is linked so that the quantity of specific items listed on the log will be automatically deducted from the master inventory sheet.

I need a way to cause it to deduct the inventory if there's only a date in the "Date Withdrawn" column, add the inventory if there's only a date in the "Date Added" column, and leave the total alone if there's dates in both columns (i.e., the equipment was used, then returned, so the total should be the same). The file is attached below.

Equipment Inventory.xlsx