Remove time stamp from date in XLS

Using the INT Formula

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.

Below is the INT formula that can do this:

=INT(A2)

The above formula takes the cell value as the input and returns only the integer part and removes the decimal part. Since dates are stored as integer values and time is stored as fraction/decimal in Excel, when you remove the decimal part, you are only left with the date part.

But you still see the time part (12:00 AM) in the result… why is that?

That’s because of the format of the cell, which is forcing it to show the date as well as the time. And since the time value is 0, it shows 12:00 AM for all the cells.