This will open the Format Cells dialog box This means that you do not actually remove the time from the time stamp, but only hiding the time part.īelow is an example, where I have the same date value in both the cells, but since these are formatted differently, you see the time in one and not in the other.Īs you can see in the image above, the formula bar shows the date and time both while the cell only shows the dateīelow are the steps to remove/hide the time from the date by changing the cell formatting: If all you want is to show the date and not the date and time both, you can easily do that by altering the format of the cells in Excel.
Remove Time from Date in Excel Using Formulas.
