How to add automatically increased date in Google docs in 10 seconds!

In a nutshell
1. Select column "A" and press Ctrl + Shift + 3
2. In cell A1 enter =41142 hit Enter
3. In cell A2 enter =A1+1 hit Enter
4. Drag (cell A2) the lower-right corner Black cross down.

I wrote this tutorial, because the normal way didn't work for me. Normal way: Insert date in the desired cell and drag the black cross down.


Solution: Automatically Increase date in each row in a column
In detail
1. Open a new spreadsheet or your existent one. Let's say you want to create auto increased date column in column 'A'
2. Convert column to date format.
Click on the top of column A to select all the column.
Select the entire column by moving the mouse pointer of the letter at the top of the column and click on it. Everything at the top of the column to the end of the spreadsheet vertically, should now be selected.
Press Ctrl + Shift + 3
Now your column "A" is converted to date format.
note: you won't see anything, but in the background it will change.

How to add automatically increased date to google docs spreadsheet

3. Fill in the A1 cell the number of elapsed day since 01/01/1970. Let's say today is august 21 in 2012 so
=41142
day elapsed since 01/01/1970.
note: begin with an equal sign.

How to add automatically increased date to google docs spreadsheet

3. With the A2 cell selected,  fill in
=A1+1
note: begin with an equal sign.
Now copy this in all the A column. Point the cursor to the lower-right corner of cell A2. The mouse pointer should change to a small black cross. Click on it and drag down over the cells in column "A".

How to add automatically increased date to google docs spreadsheet

How to add automatically increased date to google docs spreadsheet

How to add automatically increased date to google docs spreadsheet