How to remove time from date in excel

[admin]

Change the Format to Hide the Time from Timestamp

1. Select the cell in which you have the time stamp from which you want to remove the time.
2. Hold the Control key and then press the 1 key. ...
3. In the Format Cells dialog box, select the Number tab.
4. In the left pane, click on the Date option.