General discussion
-
Topic
-
Excel formula to count the days my items where in stock
LockedHi,
Till now when i wanted to know how much i sold in 3 months i pulled a report on how much got sold in the last 3 months but the problem i had was if the item was out of stock for 60 days and i pulled the report for 3 months it told me for example you sold 500pcs when really i sold this amount in only 30 days because it was out of stock for the rest of the time.
So i’m looking for a excel formula that i can ask how much got sold in the last 90 days and it only counts the days the item was in stock.
Please Help!
Thanks, Sol