How to Change Date Format in Excel Office 365? – {Simple Ways}
Tags: changethedateformat, kutoolsexceltutorial, kutools
Published: 2020-10-16 11:58:57

---
title: How to Change Date Format in Excel Office 365? – {Simple Ways}
published: true
date: 2020-10-16 11:49:19 UTC
tags: ChangetheDateFormat,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-change-date-format-in-excel-office-365-simple-ways/
---

In this tutorial, we will guide you to learn how to **change**  **the Date Format in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.


## Change Date Format from the US to the UK:

If you want to convert the date format from the **US (mm:dd:yyyy)** to the **UK** format **(dd:mm:yyyy),** use the **Apply Date Formatting ** tool to complete this task.

- First, you need to **select the range** that you want to change the date format.

![US date](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/US-date.png)<figcaption id="caption-attachment-15868">US date</figcaption>

- On the **Kutools Tab, select** the **Format** option, **choose** the **Apply Date Formatting** option from the drop-down list.

![Select Apply Date Formatting option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Apply-Date-Formatting-option.png)<figcaption id="caption-attachment-15869">Select Apply Date Formatting option</figcaption>

- It will open the **Apply Date Formatting Dialog box**.
- You need to **select the UK format** under the **Date formatting** section and you can see the results on the **Preview** pane.

![Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Dialog-box.png)<figcaption id="caption-attachment-15872">Dialog box</figcaption>

- At last, **click** the **OK** or **Apply** button to get the result. Now, the selected cells have been converted to the **UK date format** as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-20.png)<figcaption id="caption-attachment-15873">Result</figcaption>

## Convert Date to the Day of a Week:

Sometimes, you want to know the day of a particular date while doing some work in Excel, in that case, you need to use the **Apply Date Formatting ** utility.

- You need to **select a range** of dates that you want to change.

![select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-14.png)<figcaption id="caption-attachment-15874">select a range</figcaption>

- On the **Kutools Tab, select** the **Format** option, **choose** the **Apply Date Formatting** option from the drop-down list.

![Select Apply Date Formatting option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Apply-Date-Formatting-option.png)<figcaption id="caption-attachment-15869">Select Apply Date Formatting option</figcaption>

- It will open the **Apply Date Formatting Dialog box**.
- You need to **select** the **specified format** from the **Date formatting ** section.

![Apply Date Formatting Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4-8.png)<figcaption id="caption-attachment-15875">Apply Date Formatting Dialog box</figcaption>

- Finally, **hit** the **OK** or **Apply** button to get the result as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-8.png)<figcaption id="caption-attachment-15876">Output</figcaption>

## Change Date to Month and Year Only:

To convert the date ( **10/16/2020** ) to Month & Year format ( **October-2020** ), follow the below steps.

- You need to **select a range** of dates that you want to change.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/6-5.png)<figcaption id="caption-attachment-15877">Input Range</figcaption>

- On the **Kutools Tab, select** the **Format** option, **choose** the **Apply Date Formatting** option from the drop-down list.

![Select Apply Date Formatting option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Apply-Date-Formatting-option.png)<figcaption id="caption-attachment-15869">Select Apply Date Formatting option</figcaption>

- It will open the **Apply Date Formatting Dialog box**.
- You need to **select** the **specified format** from the **Date formatting ** section.

![Apply Date Formatting Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/7-4.png)<figcaption id="caption-attachment-15878">Apply Date Formatting Dialog box</figcaption>

- **Click** the **OK** or **Apply** button to get the output.
- Now, the selected range has been converted to **month and year only** format.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/8-3.png)<figcaption id="caption-attachment-15879">Result</figcaption>

In this way, you can easily format the dates in Excel spreadsheets.

## Bottom-Line:

In this tutorial, we guided you to know the steps to **change**  **the Date Format in Excel Office 365** using **Kutools ** with clear-cut examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Toggle All Hidden Columns to be Visible or Invisible in Excel](https://geekexcel.com/toggle-all-hidden-columns-to-be-visible-or-invisible-in-excel-365/)
- [Prevent Duplicate Entries in a Column](https://geekexcel.com/how-to-prevent-duplicate-entries-in-a-column-in-excel-office-365/)