Go Back

Series of dates by day

By using MS Excel, you can generate a dynamic series of dates that will change every day. The formula works as such that it adds one day into the first date and in this way a dynamic series of date is generated.

How to Generate Series of Dates by Day in Excel

The date system in MS excel is indicated by the simple serial number. You can add to any date by simply adding a serial number to that table.


The general formula used for this function is as below:


 Figure 1. Series of dates by days

In figure 1, A5 is the hard-coded date that is used as the basis of data while the formula used in A6 is as below:


As in the figure, excel adds 1 day to A5 and then 1 day to A6 to generate the successive date in the datasheet.

As the formula is copied down the columns, excel adds one day to each of previous day and in this way the dynamic series of dates are generated.


Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I have a data series in column of dates and counts. Not all dates have a count. I want to populate/fill in the series with the dates without a count so i can easily aggregate the data by week/month, etc. How can I do this?
Solved by F. W. in 26 mins
I have two columns, a series of dates and a series of times. I need to take the mode time of each week within the time series
Solved by V. Q. in 11 mins
I want to enter a series of dates down a column.
Solved by G. Y. in 16 mins

Leave a Comment