Windows

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.

Thanks, Sol