Excel: How to Enter the Same Day but Different Month and Year

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. 

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Microsoft Office and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s