Increment a Date By X Days for Each Row in Excel

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.