Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Related Discussions
-
7
-
9
-
4
-
0
-
1
Excel formula calculate a reorder on how much you sold when you had stock
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.