Increment a Date By X Days for Each Row in Excel

Add to Favorites
Author:

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

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Increment a Value Every X Number of Rows in Excel
Tutorial: (New Easier Version for Excel 2010 and Later) How to increment a value, number, percent, e...
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...
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...
Calculate Someone's Age in Excel
Tutorial: How to automatically calculate someone's age using Excel.  This method is simple and wil...
3 Slicer Tricks for Pivot Tables in Excel
Tutorial: 3 ways to better use Slicers for Pivot Tables in Excel. These tips will show you how to a...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course