5 Simple Ways To Remove The Time From A Date In Excel

For more Excel date info, check out our general guide on how to set a date in Excel.

Note that this only works if your date and time are separated by a delimiter like a space. For example, “1/8/23 5:34 PM” has a space between the date and the time. Since Excel stores date information as a serial number, removing the time from a date sets the date’s time to 12:00 AM. You cannot completely remove the time aspect from a date value.

You can also change where the columns will be placed using the “Destination” box.

For example, if you had the time “1/8/23 5:34 PM”, it would be split into three columns containing “1/8/23”, “5:34:00”, and “PM”.

Note that this only works if your date and time are separated by a space. For example, “1/8/23 5:34 PM” has a space between the date and the time. Since Excel stores date information as a serial number, removing the time from a date sets the date’s time to 12:00 AM. You cannot completely remove the time aspect from a date value.

Since Excel stores date information as a serial number, removing the time from a date sets the date’s time to 12:00 AM. You cannot completely remove the time aspect from a date value.

You can copy and paste the formula as needed to remove the time from other dates in your dataset.

Since Excel stores date information as a serial number, removing the time from a date sets the date’s time to 12:00 AM. You cannot completely remove the time aspect from a date value.