* Select a cell to which you want to add the date.
* Right click on the cell and select "Format Cells".
* Under the "Number" tab, choose "Date".
* Select the type of the date in the right pane.
* Hit "OK".
* Drag the "+" sign which appears in the right bottom of the cell.
* Leave the mouse control when you reach the destination cell.