yogi_From Data In Table A16:E Compute The Most Productive Day (the day with fewest 'inc') In Column E

Google Spreadsheet   Post  #2023

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-15-2016

post by: Nuclear Buckeye:

https://productforums.google.com/forum/#!topic/docs/F8fhYOeU2aM;context-place=forum/docs

Find most productive day of the week - HELP!!!

I have a list of dates in A17:A in format eg, Sat. 16-Jan. 

I also have the categories for the type of work are in cells E17:E. One category is labeled "inc", short for incomplete.

How can I find the most common day of the week, eg. Wed or Tues, that I complete the work?

Desired Result format: Saturday, e.g.

(PS - cannot share spreadsheet since it has client info on it)

------------------------------------------------------------------------------------------------------------