Excel formula calculate a reorder on how much you sold when you had stock

By shalom3 ·

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.

Thanks, Sol

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums