Geekers - Microsoft Excel is an application from Microsoft that is very helpful for speeding up work related to making a list of dates. Jobs such as making attendance lists, course lists, and daily, weekly, or monthly reports can be done by making sequential dates.
Microsoft excel has a very advanced feature to generate automatic sequential dates. To make sequential dates in Excel, you can use the autofill feature. But, maybe some of us still don't know how to make a list of sequential dates in Microsoft Excel.
Well, this time I will share about how to make a list of sequential dates in Microsoft Excel very easily. how do? Just follow the steps below.
How to Make a List of Ordered Dates in Microsoft Excel
1. First, please make a date that you want on the excel worksheet. As in the picture below.
create date create date
2. Then, please drag down the end of the right box. Then, sequential dates will appear automatically. As in the picture below.
pull down pull down
3. Done.
Sort by Month, Year, Weekdays, and Others
A. Using the Fast Way
1. Please drag down the end of the box on the date you have created. As in the picture below.
pull down pull down
2. Then, please click on the icon at the bottom right of the box. As in the picture below.
click icon click icon
3. Well, several options will appear. Please choose what you want. You want to sort by month, day, year, or weekday. For example, you want to sort instead of only. Please click “Fill Months�. As in the picture below.
fill months fill months
4. So, the date will remain the same but the month will be different. As in the picture below.
result result
5. Then, if you want to sort only the year. Please click “Fill Years�. As in the picture below.
fill years fill years
6. So, the date and month will remain the same while the year will be different. As in the picture below.
result result
7. Then, if you want to sort on weekdays only. Please click “Fill Weekdays�. As in the picture below.
fill weekdays fill weekdays
8. So, the date will be different according to working days. Dates that fall on Saturday and Sunday will not appear. As in the picture below.
result result
9. Done.
B. Using the Fill Series Menu
1. Please block the date you want to sort. As in the picture below.
pull down pull down
2. Then, please go to the Home menu. As in the picture below.
click home click home
3. Then, please click on the "Fill" menu. As in the picture below.
click fill click fill
4. Then, please click "Series". As in the picture below.
click series click series
5. Then, please choose what you want. And click “Ok�. As in the picture below.
settings settings
6. Done.
Well, how? The method is quite easy and very simple, right? Now we can sort dates automatically in Microsoft Excel. Besides the date, we can also sort by month, year, or weekday.
That's how to easily make a list of sequential dates in Microsoft Excel that you can try. If this article can help you, please share it with your friends so they also know how to easily create an ordered list of dates in Microsoft Excel. Hopefully this article can be useful for all of us. If there is a writing error please forgive. Thank you 🙂
RELATED TUTORIALS
* How to Print an Excel Sheet with Landscape
* How to Use Freeze Panes in Excel
* How to Move Tables from Excel to Word
* How to Lock Excel Files with a Password