The above formula takes the cell value as the input and returns only the integer part and removes the decimal part. Suppose you have the dataset as shown below, and you want to remove the time portion from all these cells and only have the date part.īelow is the INT formula that can do this: =INT(A2) In this section, I will show you how to do this using three Excel formulas – INT, DATEVALUE, and TEXT. There are a couple of easy formulas that you can use to remove the time portion from the time stamp and only get the date portion. In case you want to remove the time portion from the time stamp completely, better to use the formula method (covered next) or the Find and Replace method or the Text to Columns (covered after that) Remove Time from Date in Excel Using Formulas So in case you need to use the original data, you still have it intact.

It doesn’t alter the original value – only changes the way it’s being displayed.

Just select the cells with the data and change the format for those cells itself.

You don’t need a separate column to get the result.There are two good things about this method: This means that if you use these cells in any calculations, it would include the date and well as time value. Remember that this method only hides the time part and doesn’t remove it. The above steps would instantly hide the time part from the time stamp and you will only see the date. In the options on the right, select the format in which you want the date to be displayed.In the left pane, click on the Date option.In the Format Cells dialog box, select the Number tab.This will open the Format Cells dialog box Hold the Control key and then press the 1 key.Select the cell in which you have the time stamp from which you want to remove the time.

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 using Text to ColumnsĬhange the Format to Hide the Time from Timestamp.

Remove Time From Date using Find and Replace.

Remove Time from Date in Excel Using Formulas.

Change the Format to Hide the Time from Timestamp.

Change time in excel format