How do you auto-complete a column in Excell with the date from today to any other specific date?

Answer 1

1. Enter the date in a cell.
2. Click and drag the small square (Auto-Fill) in the bottom right corner of the cell as far down the column as you like.
3. Let go of the mouse button and observe the dates.

This method only copies the same date without change it .

I found a method to make change of the date :

1. Enter the date in a cell (lets say cell A1 )

2. Click the next cell under the first one( the cell B1) and then in the Formula bar put the formula " =A1+1 " ( without " ")

3. Click and drag the small square (Auto-Fill) in the bottom right corner of the cell as far down the column as you like.

P.S. : to enter a date in a cell you click in the upper tab Formulas > Date and time > Date

That way you will have on each cell all the dates you need.