How to show in excel the days with higher sales within a month?

I have a small food business. I made a worksheet to manage and control sales each day. Thanks for your help.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wayne Taylor (webtubbs)Commented:
There are a number of different ways to achieve this, but it would definitely help if you could post your workbook.
philosopher76Author Commented:
Thanks. Here is the file. Would it be possible to get the three days with higher sales, or all in a decreasing order? I mean if Excel can show something like this: In average Mondays are the days with higher income, after Fridays and finally Sundays. The information is in columns A and D.

Again thanks for your help.
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
You can create a pivot table and do the custom sorting according to the sum total.

Sort data in a PivotTable

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
You may also consider Condition Formatting or using RANK function to put a sequential number for your values.
ProfessorJimJamMicrosoft Excel ExpertCommented:
please find attached template
You've already been provided with data
A bit off topic, but I suggest you might want to consider using an excel as the data entry into a Database (Access, or MS sql (express))

This way you can have on going and much more versatile report.
weekly, monthly, yearly, etc...... comparison to seasonal/etc.
Here is a (non affiliated link to a tutorial) that might be helpful.
Kanti PrasadCommented:

If you looking for the highest sale within a month then try   =MAX(D3:D32)

if you are looking for the order from max to min the in your excel delete the row 2 so that there are not empty lines then highlight the entire excel sheet clicking at the top above row 1 and beside column A then
go to Data tab and select Sort and then
select my data has header and then
select the column you want it to sort say Sales
select highest to lowest values option and then
you will then have values from the highest to the lowest sales
Danny ChildIT ManagerCommented:
For something like this, I'd normally go to Conditional Formatting and the heat maps - see attached example.  
This is done by selecting the column of data you want to compare - Conditional Formatting.. Colour Scales.. and then choose the colours you want.  The only problem with heat maps is that one freak result can result in all other results getting "washed out" by comparison.  See for example the high Expenses value on Tues 9th.

I had to take some guesses as to which columns had  high=good, and also where high=bad, but think it's OK?

I also tidied some other areas - the percentages, and also if you now enter the 1st day of the month in cell B3, the rest of the cells nearby will update automatically.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.