Excel has a variety of methods for entering dates quickly and easily.

You can instantly fill any series you’re working with, for instance dates with 7-day intervals, or you might want to exclude weekends and fill with just using weekdays.  There are various options available for filling series’, days, months and years.

Abbreviations works well too, as long as it’s a 3-letter abbreviation like Jan for January, or Mon for Monday.

If you use all uppercase, it will fill using all uppercase, etc.

Sometimes you want to put in a date series, for example, enter the first date and by dragging the fill-handle from the lower right-hand corner it will add 1 day each time.

If you want to have the same day repeated while filling, hold down the Ctrl key while dragging the fill-handle.

You can also create a date series by entering the second date.  For instance, by adding 7 days to the first date you’ve entered.  With both 1st and 2nd date highlighted you can use the fill-handle to continue adding dates in 7-day intervals.

You can also create a series of dates by filling dates by adding 1 month instead of 1 day at a time.

Drag the fill-handle with the RIGHT mouse button.  When you let go of the mouse button the pop-up menu appears which allows you to choose how you would like to fill the series.  Choose ‘Fill Months’.

If the starting date was the last day of the month, by using this option the series will fill by always displaying the last day of the following month.

You can use the same method by dragging with the right mouse button and choose ‘Fill Week Days’ to just display dates from Mondays to Fridays, with gaps where the weekends fall.

You can also create a yearly series in the same manner by dragging with the right mouse button and choose ‘Fill Years’. 

Please subscribe to view the full article

Please subscribe to view the full article

You have Successfully Subscribed!