Calculate weekly consummation of ingredient

Acc.mero · #1 07-30-2018, 07:03 AM

Hi Everybody
today I need in cell (AC13) blank value because this ingredient shouldn't be added in this day according to sheet "Free Days" and also every red cell in product 46 in row 50

and the other thing

I need to to count week days that ingredient was added if it 6 day in every week so leave it blank and I colored this cells with blue color
and if it less than 6 days make first day blank and the second day the value in the cell I colored this cells with orange color

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to calculate weekly and Monthly Run Rate	yakhtar	Excel	1	03-06-2017 05:04 PM
Weekly Calendar- at a loss	04herrs	Excel Programming	3	02-15-2017 05:14 PM
Compiling/Indexing hundreds of recipes + adding a search by ingredient function.	batarcit	Excel	2	08-13-2014 03:09 PM
Need weekly Work log template recommendation	Shazamy	Excel	2	10-04-2013 10:50 AM
Weekly Calendar	Monoceros	Project	0	11-05-2010 03:37 AM