Remove time from date / timestamp in Excel – 4 easy ways

When working with date-time data in Excel, you may encounter datetime values like "1/24/2024 14:30:00," and you might need to extract only the date "1/24/2024" without the time part. This article will introduce you to four simple methods to remove the time from the timestamp. These methods are simple and easy to understand, suitable for various situations, and whether you are a beginner or an experienced Excel user, you can quickly learn and apply them.

Hide the time from date by changing format

Remove time from date by using a smart feature

Remove time from date by using formulas

• Using INT function
• Using DATE function

Remove time from date by using Find and Replace function

Hide the time from date by changing format

1. Select the cells you want to remove time, and right click, in the context menu, choose "Format Cells" to open the "Format Cells" dialog box. See screenshot:
   Tip: You can also use the shortcut "Ctrl" + "1" to open the "Format Cells" dialog box.
   
   
2. In the "Format Cells"dialog, under the "Number" tab:
   1). Select "Date" from the "Category" list;
   2). Select one type of date as you need from the "Type" list box;
   3). Finally, click "OK" button.
   
3. Now, the selected cells are formatted to display only the date, with the time removed. see screenshot:
   

Note: This method only conceals the time portion without actually removing it, the date and time can still be seen in the formula bar. Additionally, if these cells are utilized in any calculations, the values will include both the date and the time.

Remove time from date by using a smart feature

If you want to remove the time from the time stamp completely, "Kutools for Excel" offers a smart feature - "Remove time from date", with this feature, you can directly remove time from the datetime cell with only several clicks.

After installing "Kutools for Excel", please do as this:

1. Click to select a cell where you want to place the result, then click "Kutools" > "Formula Helper" > "Formula Helper".
2. In the "Formulas Helper" dialog, click the "Remove time from date" in the "Choose a formula" section.
3. Then go to the "Argument input" section, select a cell that you want to remove time from.
4. At last, click "OK" button.
5. 

Result:

Now, the time has been removed from the datetime, then drag fill handle over the cells you want to apply this formula as you need, see the demo below:

Remove time from date by using formulas

In Excel, there are some simple formulas that can be used to eliminate the time from a timestamp, allowing you to extract only the date portion.

Using INT function to extract only date

1. Please enter or copy the following formula into a cell where you want to put the result. Then, drag the fill handle down to fill this formula to the rest cells, you will get the date with time part (00:00:00) in the result, see screenshot:

   =INT(A2)

   
2. To not show the time part, still keep the results selecting, and then, click "Home" > "General" > "Short Date". Now, the results are displayed as date only. See screenshot:
    

Using DATE function to extract only date

To extract only the date part, you can also use the DATE function.

Generic syntax:

Please enter or copy the following formula into a cell where you want to put the result. Then, drag the fill handle down to fill this formula to the rest cells, all the dates have been extracted from the datetime cells without time. See screenshot:

=DATE(YEAR(A2),MONTH(A2),DAY(A2))

Remove time from date by using Find and Replace function

Follow these steps to remove time from dates using Excel's "Find and Replace" function:

1. Select the date range that you want to remove the time.
2. Press "Ctrl" + "H" or navigate to "Home" > "Find & Select" > "Replace" to open the "Find and Replace" dialog box.
3. In the "Find and Replace" dialog box:
   1). Enter a spacebar and an asterisk * into the "Find what" box;
   2). Leave blank in the "Replace with" box;
   3). Finally, click "Replace All" button.
   
4. Now, all of the time have been removed from the date range, the date may still display with a time portion of 00:00:00. See screenshot:
   
5. Then you can format the range to show only the date by clicking "Home" > "General" > "Short Date". See screenshot:
   

Related Articles: