General discussion

  • Creator
    Topic
  • #2340863

    Excel formula to count the days my items where in stock

    Locked

    by shalom3 ·

    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

All Comments