Undoubtedly, this particular problem is the absolute LOWEST priority of any calculations I need. I worked out an answer but it is again clunky and takes up a bunch of real estate.
In a list of dates, I am looking for the max number of occurrences in any one weekend, defined as Fri., Sat., and Sun., and the dates of that weekend. The data contains duplicates but will always be chronological.
In my clunky solution, I listed all of the possible weekends and then counted occurrences in each weekend. Is there a less caveman-like way of obtaining the same results? Ideally, I would like to eliminate columns C:E. Adding a helper column or two to the DATA would be acceptable.
I would appreciate any help but please don’t lose any sleep, it isn’t all that important.