Discussion Locked

Excel formula to count the days my items where in stock

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

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

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.