After Hours

General discussion


Excel formula to count the days my items where in stock

By shalom3 ·
Tags: Off Topic

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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums