We all want faster ways to enter data and you’re probably already aware of the autofill feature in Excel. To enter a series of consecutive dates you just need to enter the one date and then click and drag on the bottom right of the cell when the crosshair appears. But you can do some clever things like just get the month to increase or the year. You can also get it to just fill the weekdays and leave off the weekends.
These options are available if you use the right mouse button to autofill rather than the left. When you use the right mouse button a menu will appear when you finish dragging with these options.
You can see how this works in the video tutorial below.