How to Insert a Date or Formatted Date in Excel Office 365?
Tags: kutoolsexceltutorial, stepstoinsertadateor, kutools
Published: 2020-10-16 11:59:09

---
title: How to Insert a Date or Formatted Date in Excel Office 365?
published: true
date: 2020-10-16 11:45:17 UTC
tags: KutoolsExcelTutorial,StepstoInsertaDateor,Kutools
canonical_url: https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/
---

In this article, you will learn how to **Insert a Date or Formatted Date in Excel Office 365** using **Kutools.** Let’s get into this article!! 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.


## Insert a Date or Formatted Date:

Take a look at the [**Date & Time**  **Functions**](https://geekexcel.com/date-and-time-functions-in-microsoft-excel-365/) to know more about using dates and time in Excel.

To insert a date in the cell in the Excel spreadsheet, you need to follow the below steps.

- You need to **select a cell** where you want to insert the date. Here, we have selected the **cell B2** in the below image.

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

- Go to the **Kutools Tab, select** the **Insert** option, **choose** the **Insert date** option using the drop-down list.

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

- It will open the **Insert Date dialog box**.
- Now, you need to **select** any **date** that you want to insert and **double-click** on it.

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

- The selected date is inserted into the specified cell as shown in the below screenshot.

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

### Note:

- You can also **insert the date in a certain format** by **selecting** the **Using format** option and multiple date formats are listed on the right pane of the dialog box.

![Check the Using format option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Check-the-Using-format-option.png)<figcaption id="caption-attachment-15843">Check the Using format option</figcaption>

- You need to **select any date format** and then **choose** the **date** that you want to insert from the calendar and **double-click** on it.

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

- Then, you can see the result in the selected cell.

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

- The dialog box will not close until you **click** the **Close** button, so you can insert more dates in a certain format in the spreadsheet.

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

## Verdict:

In the above article, you can clearly understand the steps to **Insert a Date or Formatted Date in Excel Office 365** using **Kutools. ** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See 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/)