How to Remove Time from Date Time Format Permanently In Excel?
Tags: kutools, removetimefromdateti
Published: 2020-08-10 11:55:53

---
title: How to Remove Time from Date Time Format Permanently In Excel?
published: true
date: 2020-08-10 05:13:04 UTC
tags: Kutools,RemoveTimefromDateTi
canonical_url: https://geekexcel.com/how-to-remove-time-from-date-time-format-permanently-in-excel/
---

## Remove Time from Date Time Format Permanently In Excel:

In this tutorial, we will guide you to learn how to **Remove Time from Date Time Format in the cells in Excel** 365 using **Kutools**.

Here we come up with the special feature to remove time from the date-time format in Excel that is **Formula Helper** function. It is one of the built-in functions in Kutools. We will use this to solve our task quickly.

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 120 features. In this article, we will solve this task using only the Kutools function. If you want to use Kutools, you need to install it from Excel’s official website.



## Remove Time from Date Time Format Cells in Excel:

To remove time from date-time format cells in Excel, do as follows.

- We have created an example to make you understand this concept easily.
- The following screenshot has shown the list of date-time format cells.

![Date Time Format Cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-11.png)<figcaption id="caption-attachment-11453">Date Time Format Cells</figcaption>

- Now, Select any blank cell from the spreadsheet to place the result.
- Go to the **Kutools** tab, **select** the **Formula Helper** Option, Choose the **Date & Time** option.
- Then, select **Remove time from date** option from the menu list.

![Remove time from date option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-9.png)<figcaption id="caption-attachment-11454">Remove time from date option</figcaption>

- It will open the **Formula Helper dialog box** , **select the range of cells** that contains date-time format using the given button in **Date time option**.

![Formula Helper Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-9.png)<figcaption id="caption-attachment-11455">Formula Helper Dialog Box</figcaption>

- Then, hit the **OK** button to see the result in the selected cell. It will display only the date in the selected cell.
- Now, you need to **drag it down** to fill other cells and get the output like the below image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-9.png)

### Note:

- You can also apply the following formula to remove time from the date-time format cells.

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

- To find a formula quickly in the **Formula Helper** dialog box, you have to **check** the **Filter**  **box** and search using the keyword.

![Filter Check Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/5-9.png)<figcaption id="caption-attachment-11459">Filter CheckBox</figcaption>

- You can share this feature with your friends using the **share** button in the **Formula Helper Dialog box**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/6-9.png)

## Wind-Up:

In the above article, you can understand the steps to **Remove Time from Date Time Format Cells** in **Excel** 365 using **Kutools**. Kindly, drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [Shortcut to Delete Contents of Selected Cells in Excel 365](https://geekexcel.com/shortcut-to-delete-contents-of-selected-cells-in-excel-365/)
- [Excel Calculate Date & Time:Add, Subtract Datetime, Time Difference, Age Calculation](https://geekexcel.com/excel-calculate-date-timeadd-subtract-datetime-time-difference-age-calculation/)
- [How to Apply Phone Number Data Validation to Cells in Excel 365?](https://geekexcel.com/how-to-apply-phone-number-data-validation-to-cells-in-excel-365/)