Open In App

How to Remove Time from Date/Timestamp in Excel?

Improve
Improve
Like Article
Like
Save
Share
Report

Timestamp stores a combined Date and Time value. In this article, we will look at how we can create Timestamp and remove Time from Date in Excel. 

To do so follow the steps below:

Step 1: Formatting data to create a timestamp.

Select the cell, right-click on it choose Format Cells…

Step 2: Then in the Formal Cells box select Custom in Category and in the type select dd-mm-yyyy hh:mm, and then click Ok.

Then, we will enter our date with time in the cell.

To remove Time from Date with Format Cells

Step 1: Highlight the cells to remove time from date.

Step 2: Then right-click on it and choose Format Cells…

Step 3:-Then in the Format Cells box select Date in Category and select *14-03-2012 in Type, and then click Ok.

After that time is removed from the date.

To remove Time from Date with Find And Replace Function

Step 1: Highlight the cells to remove time from date.

Step 2: Then, click to Home on the Ribbon. In the Editing group, click Find & Select.

Step 3: In the resulting menu click Replace…

Step 4: Then in Find and Replace box enter the space bar and * in Find what box and leave a blank in Replace with box, then click Replace All.

After that time is removed from the date.

To remove Time From Date With VBA Code

Step 1: Highlight the cells to remove time from date.

Step 2: Press Alt + F11 then a Microsoft  Visual Basic for Applications window will be displayed and then click Insert.

Step 3: Then in the resulting menu click Module.

Step 4: In the Module write the following code.

Step 5: Then, click on the red marked button as shown below to run the code.

Step 6: In the KutoolsforExcel box select the range from which we want to remove time and then click Ok.

After that time is removed from the date.

To remove Time From Date With Kutools For Excel’s Remove Time From Date Function

Step 1: Visit on the given link below to install Kutools for Excel

https://www.extendoffice.com/download/kutools-for-excel.html

Step 2: Then, click to Kutools on the Ribbon. In the Formula group, click Formula Helper.

Step 3: In the resulting menu click Formula Helper…

Step 4:- In the Formulas Helper box select Date in Formula Type then choose Remove time from data in choose a formula box then select the range from which we want to remove date in Date time box and then click Ok.

After that time is removed from the date.


Last Updated : 20 May, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads