Dear Excel gurus!

I have several pivot tables with the dates going down the left hand side and individuals names running along the top. The data in the table are sales figures. This shows me how much money each of my sales people are generating each month. But what I would love to know is, how much money are they generating on a daily basis? So... is it possible to put something into a calculated field to allow me to say 'sales/month' to give me the average number of sales per day during each month?

Any help would be massively appreciated.

Thanks

Will