Workdays in a week when orders exceed 600

[clarkpaul]

This may be simple but I can't wrap my head around it.
I have a matrix based on week end dates.  I want to be able to call out the weeks that are in progress.

For example today is 12/3 and our week end is 12/4.  There are 5 workdays in this week but I only
have data to 12/2. 

A workday would have > 600 orders, so if a day had more than 600 orders it would be counted as
a complete work day.

Any help would be greatly appreciated!

[Anonymous]

Hi @clarkpaul 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regard

Community Support Team _ Ailsa Tao

[Anonymous]

Hi @clarkpaul 

What is the final result you want ? If the number of orders is greater than 600 , then the day can be counted as a complete work day and calculated in Matrix , right ? If this date is on weekends or holidays, it cannot be calculated in the Matrix, right ?

Could you provide a simple sample, including date and order quantity , and the final result you want . It will help us to deal with your issue easily .

Best Regards

Community Support Team _ Ailsa Tao

[clarkpaul]

@Greg_Deckler 
Yes, I would use conditional formatting to turn the week end date cell yellow.
I have a table that has creation date and a unique order number.  I have a date table that disregards weekends and holidays, you'll notice the week end date of 11/27 has only 3 work days.  Thanksgiving and the Fridays are holidays for us.
On weekends and holidays we may receive a couple of hundred orders but always less than 800.  A normal day would have more than 1,000.

[Greg_Deckler]

@clarkpaul So using something like conditional formatting? Would need to understand your data better.