• Creator
  • #2340862

    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

All Answers

Viewing 0 reply threads