Still not automatically filling in working days? In fact, it is very simple to operate in Excel. Below, I will share the tutorial on how to automatically fill in working days in Excel. Let’s take a look. I believe it will be helpful to everyone.
Method 1: Pull-down method
Enter the start date in the form. Do not enter this directly into the cell, but enter it using a formula. It is the direction pointed by the red arrow, otherwise the cell input does not have a year but only the month and day.
Put the mouse on the lower right corner of the starting cell. At this time, the mouse turns into a "cross". Pull it down to the date you need. The stop row will display the date of the row, so you don't need to calculate it yourself.
After releasing the mouse, we find that all dates have been filled in. We can find a small cell-like frame in the direction pointed by the red arrow in the lower right corner. Click on the "small triangle" on the right side of it.
After clicking the "small triangle", a drop-down dialog box will pop up. Select "Fill with working days" in the middle, and click the mouse in the small circle in front of "Fill with working days (W)".
Then when you look at the worksheet, you will find that there are two days missing from May 1st to May 12th, the 7th and 8th, and these two days are Saturday and Sunday, and the rest are working days, of course. National legal holidays need to be marked separately.
Method 2: Toolbar setting method
First, enter the date, and then use the drop-down method to enter all the times and dates. The method is to enter the starting date in the formula, then place the mouse on the lower right corner of the starting cell to form a "cross" and pull down.
Find "Rows and Columns" in the "Start" toolbar, click the "small triangle" next to it to display a drop-down menu, select "Fill" - "Sequence", which is pointed out by the red arrow in the picture, you can take a closer look picture.
After clicking "Sequence", a dialog box will pop up. We find "Date" and "Working Day" and click on the small circle in front. The step value can also be set, and finally click "OK".
After “confirming”, we found that the final answer obtained by this method of automatically filling in working days and the previous method are the same. As for which method is more convenient, it depends on everyone’s preferences.
The above explains the specific operation process of Excel automatically filling in working days. I hope friends in need can learn it.
