Filling a Range with a Series of Dates in Microsoft Excel 2010

In this article we will learn about to fill  a range with a series of Dates in Microsoft Excel 2010.

To filling a range with a series of dates you can use here “Auto Fill Option”. It appear when you drag any cell content down to the cells.A blue link get activated this is called “Auto Fill Option”.

Microsoft Excel has some inbuilt series such as Month, Week, Serial nos, date series etc.

When we fill the series of date, there is a possibility that it may be required date in series, month in series and year in series.

For the Month series Auto Filling option is already having the option for fill the series in month, date, and year.

Let’s take an example and understand how we can use Auto Fill option in Microsoft Excel.

We have date in Cell A1, now we want the date till the A10 cell in series.

To create the series follow below given steps:-

  • Select cell A1 and drag it with the help of mouse.
  • In cell A1 select Fill handle in the right bottom corner “+” sign would be displayed, hold the pointer and drag it vertically to A10 and then release the mouse.


  • When you will release the mouse then a blue link will get activated in the bottom right corner of last cell A10.
  • Click on blue link then a drop down list will appear in which 9 options are available Copy Cell, Fill Series, Fill Formatting Only, Fill without Formatting, Fill Days, Fill Weekdays, Fill Months, Fill Years, and Flash Fill option.


  •  For day series click on “Fill Days”.


  • For Month series click on “Fill Months”.


  • For years series click on “Fill Years”.


Note: If you want to fill the series of days, click on Fill Days. For the month series click on Fill Month and for the years click on fill Years.

This is how we can fill the range with a series of dates through Auto Fill option in Microsoft Excel 2010 and 2013.


  1. Hello I am trying to format a chart with a 7 day sequence starting from 5/25/2020. For example it will be 5/25/2020, 6/1/2020 & so forth till the end of the year. How would I input that formula?

    Thank you!

    • It could be two things. Either the cell width is less or the date you are filling is negative. Excel does not recognize negative dates.

      I have explained dates in excel here

      I hope it helps.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.