Excel gurus

I am working on creating a dashboard for my company. For one of the items of the dashboard I would like to display the number of assessments that occur on each day of the week. Mon thru Saturday). The pivot table is pulling from rows that contain a date that an intake with an assessment has occurred. I have generated an additional column which converts the dates to days of the week. When I drop the day of the week into the column, the pivot table will count the number of days but it will not allow me to generate an average for the day of week. I want to know (based on the number of days I have in my data) what the average number of assessments are for each day of the week without receiving an DIV error (i.e. Monday avg throughout the year 4 assessment per day, Tuesday avg 8 assessment, etc). Please help.