Increase Incrementally

I use to be able to do this.

Put your first date in cell 1
Put your second date in cell 2

Make your second cell the date you want to increase by, so if you want to make each new cell the next day then in cell 1 you would have

1/10/10

and in cell 2

2/10/10

highlight both cells and then hover over the bottom right of the last cell and your cursor will change to a black + symbol

Drag down the cells through the blank cells you want to auto fill.

Excel will add a new date but +1 to the month in each cell you drag through.

It also works for things like days and other strings where there is a logical next value.

I would do this for example, I would first increase the hours in increments of one. Then I would increase the days by 1. However, now when I try to do it it only increases the minutes by 1 and alternates the days I have entered. See the attached excel file.

THANKS SO MUCH TO WHOEVER CAN HELP!

Hello,

the cells look like dates, but they are really text, hence the increment does not work correctly.

Make sure the cells contain real date/time values and try again. They will increment by hours if the difference between the two cells is one hour.

Test if the cells are dates: Format the cells with General. They should show numbers.

To change the text to time values, select a cell, hit F2 and Enter. Repeat for the next cell. Format with your preferred date/time format and then use the fill handle.

cheers,

In A37 and copy down, =A1+1

No, you'd have to filter the list, copy the visible cells to a new workbook and save that as CSV.