M
mgalloway
I have created a simple spreadsheet that contains the following data for
2006
Column A - WEEKDAY function reading from Column B (values 1-7)
Column B - date
Column C - # of Orders
Column D - Total Revenue
Column E - Avg Revenue per order
Each row in the spreadsheet is a date of 2006, starting with Jan 1. My
challenge is to create a formula that pulls all of the info for a given
day of the week and creates benchmarks for trend analysis. For
example, I want calculate the average number of orders received on a
Monday from Jan 1 - present. Data for future dates are prefilled with
0. Sample is as follows:
A B D D
E
1 01/01/2006 82 14201.70
173.19
2 01/02/2006 155 23339.30
150.58
3 01/03/2006 171 27979.57
163.62
1 01/08/2006 154 34360.55
223.12
2006
Column A - WEEKDAY function reading from Column B (values 1-7)
Column B - date
Column C - # of Orders
Column D - Total Revenue
Column E - Avg Revenue per order
Each row in the spreadsheet is a date of 2006, starting with Jan 1. My
challenge is to create a formula that pulls all of the info for a given
day of the week and creates benchmarks for trend analysis. For
example, I want calculate the average number of orders received on a
Monday from Jan 1 - present. Data for future dates are prefilled with
0. Sample is as follows:
A B D D
E
1 01/01/2006 82 14201.70
173.19
2 01/02/2006 155 23339.30
150.58
3 01/03/2006 171 27979.57
163.62
1 01/08/2006 154 34360.55
223.12