I have an inventory # that auto-calculates on when an item is sent. Now I need to know expected inventory of the item based on a certain future date.
I have the following:
A1. Date the item was shipped to a client
B1. Date the item is due back from the client
C1. Number of current inventory of item
Which formula helps me to calculate the expected inventory based on these cells.
Thank you in advance.
Ruzzo
I have the following:
A1. Date the item was shipped to a client
B1. Date the item is due back from the client
C1. Number of current inventory of item
Which formula helps me to calculate the expected inventory based on these cells.
Thank you in advance.
Ruzzo