How to Remove Time from Date in Excel?

Excel is a strong programme that is frequently used for reporting, data analysis, and data manipulation. You could frequently get into circumstances while working with date and time data where you need to split the date portion from the time portion. With the integer portion representing the date and the decimal portion indicating the time, Excel stores date and time values as serial numbers. This step-by-step tutorial will show you how to use a variety of techniques to eliminate the time element from date values in Excel. We will investigate straightforward yet efficient methods to extract only the date while leaving out the time, regardless of whether you have a list of dates with accompanying times or a combination of date-time data.

All users, from novice Excel users to experts, can benefit from this course. By the end of this tutorial, you should be able to select the option that best satisfies your unique requirements by having a thorough grasp of the many ways to remove time from dates in Excel. Let's get going and utilise Excel's full potential to effectively work with date data!

Remove Time From Date

Here we will format the range of cells to complete the task. So let us see a simple process to learn how you can remove time from a date in Excel.

Step 1

Consider an Excel sheet where you have a list of dates along with times, similar to the below image.

First, select the range of cells, then right-click on cells and select format cells.

Select Cells > Right-Click > Format Cells.

Step 2

Then click on date, select a specific format, and click OK to complete the task.

Date > Format > Ok.

Then you will see that time will be removed from the selected cells.


In this tutorial, we have used a simple process to learn how you can remove time from a date in Excel to highlight a particular set of data.

Updated on: 13-Sep-2023


Kickstart Your Career

Get certified by completing the course

Get Started