Saturday, January 16, 2016

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   Jan-15-2016
post by: Nuclear Buckeye:!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)