I have a table with two columns: column A has dates, column B has data. I want to compute the average of the data in B that corresponds to only week (work) days. How can I write it as a formula?
migrated from superuser.com Aug 7 '12 at 6:32
You can use the WEEKDAY functionality to determine the day of the week, and then compute the Average of all days that are not Sunday (1) or Saturday (7).
The you would need a collection of SumIF statements for each week day 2-6, and a count of them to determine an average.