Consider a table or range with three columns for the entire year 2022: date, day of the week, and sales. I need to be able to figure out how much money is typically sold on a Monday, Tuesday, etc. How would I input sales data for each Monday in 2022 into the Average() function using Visual Basic?
