Autofill Date in Excel Sheet columns

Hope everyone aware of filling Numeric values and filling Numeric series in Excel sheet(Microsoft). We can achieve filling Numeric values by just dragging the particular cell and filling Numeric Series by dragging the particular cell along pressing 'Ctrl' Key.

Filling Numeric value '1' from cells B2 to B11

Filling Numeric value '1' from cells B2 to B11

Filling Numeric series - '1 to 10' from cells B2 to B11

But what shall we do to fill Date values in excel columns.This can be achieved by dragging the cell by right clicking. You can choose either Day,Week,Month and Year.

Step-1

Step-2

Reference: http://www.techrepublic.com/article/use-excels-autofill-to-generate-a-series-of-dates/