I buy and sell different items. I am trying to write a formula that will work out how long an item stayed in stock. For example:
A1 is Purchase Date, so I enter 1st June 2018 A2 is Sale Date, A3 is No. of Days in Stock
Now if I use:
A2-A1 -- This will give me the no of days only if there is a value in A2. If there is no value in A2, I will not get an output.
If I use
I will get a value in A3 but this is not correct.
I am looking for a formula that will give an output in A3 based on how many days it took me to sell an item.
If there is no Sale Date in A2, it will continue to give me the number of days since Purchase Date (A1).
If there is a Sale Date in A2, it will work out the days from Purchase to Sale but not continue to add any more days.