Thread: Calculate weekly consummation of ingredient
View Single Post
 
Old 07-30-2018, 07:03 AM
Acc.mero Acc.mero is offline Windows 10 Office 2016
Banned
  
Join Date: Jul 2018
Location: GB
Posts: 1
Acc.mero is on a distinguished road
Default Calculate weekly consummation of ingredient
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
Attached Files
File Type: xlsx Sample 2.xlsx (138.7 KB, 15 views)
Reply With Quote