I have a long column of dates in yyyymmdd format and sales $ in another. I
wish to find what my average sales are for each day of the week ie. Mon Tue
etc. from the col. of dates that I have. I would prefer to do this in a pivot
table but if that is too complex then within the data sheet is OK .

Hope someone can help.Thanks