Quick, clean, and to the point

Series of dates by day

Excel formula: Series of dates by day
Generic formula 

If you need to generate a dynamic series of dates with a formula that increase by one day from a single start date, you can do so a very simple formula that simply adds 1 to each date.


In the example, B6 is the hard-coded start date and the formula in B7 is:


Because dates in Excel are just serial numbers (the first date in the standard Excel date system is January 1, 1900), you can adjust dates just adding or subtracting values. To solve this formula, Excel just adds 1 to the date in B6.  The first formula therefore returns a new date of 1/31/2000, one day later than the starting date.

Once the first formula is entered, it is copied down as far as needed. Each subsequent formula creates a new date incremented by one day. You could easily adjust the formula generate future dates by weeks, by using 7 instead of 1, like so:

Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.