How to Sort by Date in Excel - ExcelPro

preview_player
Показать описание
In this video we're going to learn how to sort by date in Excel. It's a straightforward method using the excel date formula as well as the excel today's date formula. Between these functions we will show you how to sort by column either ascending or descending order excel.
Рекомендации по теме
Комментарии
Автор

I've been trying this for 5hrs now. That paste as value thing was valuable. Thanks.

deepeshsharma
Автор

This was so helpful! Thank you very much.

sakurawarrior
Автор

Excellent video. Very easy way of explaining. Thanks.

shriidharkulkarni
Автор

How would i set my worksheet to automatically organize my data by the date. Let's say I have a monthly report and at the end of the month I forgot to enter a line and I want to automatically have it go in the order that it needed to be without having to highlight the entire worksheet. Is that possible? Hope that makes sense. I am new to Excel and found this video very helpful. Thank you

stevenf.
Автор

I have prepare PIVOT table and Date are not in right order.. How can we get in order in PIVOT table

Mad
Автор

Like to find a way to sort Employee name by date and once that employee worked moved them to the bottom of the active sheet

michaelmcwhorter
Автор

Is there a way to sort by the date without having to highlight all of the other info in the chart? Is there a setting where Excel will sort the other info in the row too?

michaelchilders
Автор

That was excellent and quick...
You did help me to have a great day!! lol ;)
Thank you!

frigidworld
Автор

Hi if someone can help me
I need sort workers by seniority. I will pick 20 tendon workers from column A where all are sort by seniority, and paste them in column B with not seniority order, then I need to sort them by seniority..
Thanks for help Jerry

jerryluxik
Автор

"in order to do this all cells must be the same size" This is the message i keep getting. Is there a way around this? .:. I made a list of itemize expenses. .:. I merged cells together. Date is 1 Cell, Category is 2 Cells, Description is 11 Cells, Cost is 1 Cell .:. "Merged Across Left to Right" .:. I want to be able to sort all data by date. I would be happy to send a screenshot or email a copy to show what I am looking at.

danielhelderman
Автор

I came here for a quick, simple way to sort by date. I didn't need half the video to complicate things with an automatic way to populate the date field with random dates.

willardchi
Автор

Your video is missing a huge piece of your cells have to be formated correctly.

willwebb
Автор

I have Excel Sheet created with Quick Books and it will not sort by date.

subbashpatel
Автор

Ok.. understand....but how to sort by month

guidelines.