How to count average unique values by the day of the week?
I have a data set of about 30000 lines that consists of dates in the format of MM/DD/YY in one column and I have unique Names in another column. I am trying to find a formula that would convert the MM/DD/YYYY format into a day of the week (let's say Monday) and calculate the average count of unique names for that given day for the past X months.
Posted Jun 4, 2020, 11:47 PM UTC
16