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


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

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...