I work at a Resturant and we of course use excel to do all of our daily sales inputs to find out our deposits each night. We also use quick books to enter everything just for information purposes. I've been playing around with the date formula but can't quite figure it out.

The desires are to take the daily sales totals sorted by day of week and create an additional spreadsheet that grabs those daily sales and puts them into a top 10 so I no longer have to do it manually.

Right now it's a month by month template spreadsheet that counts to 31 and we just enter up to the end of the month and name it that month so for example February ends the 28 but still 3 days left on the template.

Would I need to make a spreadsheet for every month? I assume not but any information would be awesome. I know I can pull the numbers from one spreadsheet to another but to sort them into days of the week and the. Find only the top 10. I'm sure it's probably easy but I'm still learning. Thanks for any info!

Corey