hello there,

i have a template in excel2007 that is blank until the data will begin to be
entered, in column A i have the date in the format 14/03/01, in column D i
have hours worked (in regular number eg 2.89) and in column M i have output
in units.

i was wondering if there was a formula that could return the average hourly
output and total output in the style below?

Average Hourly Output Total Output
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday

i have tried setting up another column that corresponds to the date column
A, and trying to get the above the long way using the formula
=TEXT(A2,"dddd") but as it is based on empty cells, all the blank cells come
up with 'saturday' or the last value,

any help would be great thank you!

--
cheers