Excel Formulas to Generate Series of Date by Day ~ Easy Tricks!!

Recently, there has been just one easy way to generate dates in Excel – the AutoFill feature. You can also make a series of dates with formulas too. This article provides the simple tricks to generate a dynamic series of dates with a formula that increases by one day from single start date in Excel. Let’s step into the article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

The below formula is used to generate a dynamic series of dates with a formula that increases by one day from a single start date.

=date+1

Syntax Explanations:

Date – It represents the input starting date on your worksheet.
Plus operator (+) – This symbol is used to add the values.

Example:

Refer to the below example image.

Here we will enter the starting date in Column B.
Now we are going to create a dynamic series of dates with a single start date.

So, apply the above-given formula and press the ENTER key.

Finally, you will get the result as shown below.

Bottom-Line:

Here, we have described the simple formulas to generate a dynamic series of dates by day in Excel. Hope you like it. Let me know if you have any doubts regarding this article or any other article on this site.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **