Excel formula to count the days my items where in stock

General discussion

Creator

Topic
January 28, 2016 at 5:35 pm #2340863

Excel formula to count the days my items where in stock

Locked

by shalom3 · about 7 years ago

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

This conversation is currently closed to new comments.
Creator

Topic

All Comments

This policy describes guidelines your organization can follow to track, process and decommission IT equipment. From the policy: SUMMARY An organization’s IT hardware inventory constitutes a significant capital investment in order to perform company operations. Because hardware represents a critical asset and often holds organizational data, it is important for the company to track each ...

Whether an infection is the result of a disgruntled employee, hardware vulnerability, software-based threat, social engineering penetration, robotic attack or human error, all organizations must be prepared to immediately respond effectively to such an issue if the corresponding damage is to be minimized. Because even the best protected networks become infected, all organizations must have ...

Every operating system should be appropriately secured, especially end user workstations which often contain or permit access to company data and upon which most employee job duties are based. To get the maximum security protection out of your Windows 10 deployments follow this checklist from TechRepublic Premium. Also included in this checklist: Security solutions Product ...

After Hours

General discussion

Excel formula to count the days my items where in stock

All Comments

Hardware inventory policy

Malware response checklist

Checklist: Securing Windows 10 systems

Cloud data storage policy