Increment a Date By X Days for Each Row in Excel

Add to Favorites

How to quickly increment a date by a certain number of days for each entry.

  1. Type the first date in a cell. Make sure that it's in a format that Excel recognizes as a date, such as in my example.
  2. Go to the next cell under that and enter the next date that you would like to appear.
  3. Select both cells:
  4. Put your mouse over the bottom right of the black square around the selection. Left-click with the mouse, hold, and drag down. (The small square in the bottom right of the selection is called the quick-fill-handle.)

  5. When you let go of the quick fill handle, you will have a list of evenly incremented dates.

Notes

This is a nice little tip that saves you time when building out your spreadsheets. It also works with numbers, months, and days.

Download the file attached to this tutorial to see this in Excel.


Downloadable Files: Excel File

Similar Content on TeachExcel
Increment a Value Every X Number of Rows in Excel
Tutorial: How to increment a value, number, percent, etc. every so many rows in Excel. This tutorial...
Years, Months, Days Between two dates in Excel
Tutorial: I have found a rather convoluted method to Calculate the Number of Years, Months and Days ...
Shade Every Other Row in Excel Quickly
Tutorial: How to shade every other row in Excel quickly without using the Table feature. This method...
Calculate Someone's Age in Excel
Tutorial: How to automatically calculate someone's age using Excel.  This method is simple and will...
Group Data Together for Increased Readability in Excel
Tutorial: How to group data together or collapse it in order to focus only on the important data in...
Get the Number(s) Out of a Cell that Contains Both Text and Numbers in Excel - UDF
Macro: This free Excel UDF allows you to get the numbers out of a cell that contain both text...