Excel offers some very important functions for date and times. To get the current date and time we can use the NOW and TODAY functions. In this tutorial, we will learn how to insert current date and time in Excel.

*
Figure 1. Current Date and Time in Excel*

**How to Insert Current Date and time in Excel**

To get the current date and time from our system in Excel, we can use the NOW() function. This function updates the time and date every time the worksheet is opened.

**Syntax**

**=NOW()**

The NOW function does not have any arguments. It shows the current date and time from our system. Every time we open or recalculate the worksheet, NOW updates the date and time.

To show the current date and time in cell **C2**, we can use the formula

. This shows the current date and time in cell C2. **=NOW()**

*Figure 2. Example of How to Insert Current Date and Time in Excel*

**How to Insert Date in Excel**

If we want to display the date only, we can change the date format. We can also use the TODAY function. It shows the date from our system.

**Syntax**

**=TODAY()**

TODAY in Excel also works like the NOW function. It only displays the date and updates every time the worksheet is opened. To display the current date in cell **C3**, we use the formula `=TODAY()`

.

* Figure 3. Example of How to Insert Date in Excel that Updates Every Time*

**How to Insert Current Time in Excel**

If we need to insert the current time in a way that will not change, use the keyboard shortcut **Ctrl + Shift + ;**

* Figure 4. Example of How to Insert Date in Excel that Does not Update*

This shortcut will insert the current time in a cell. This value will not change automatically. To insert both the date and time in a cell, we need to use the keyboard shortcut **Ctrl + ;** Next, we have to enter a **space **character and press **Ctrl + Shift + ;**

* Figure 5. Example of How to Insert Current Date and Time in Excel that Does not Update*

**How to Insert Current Date and Time from your System in Google Sheets**

We can insert the current date and time in Google Sheets using the NOW and TODAY functions.

To insert the current date and time in Google Sheets, we need to

- Go to cell
**B2**. - Assign the formula
`=NOW()`

. - Press
**Enter**.

This will show the current date and time in Google Sheets.

*Figure 6. Example of How to Insert Current Date and Time in Google Sheets*

By using the TODAY function, we only get the current date in Excel. To show the current date in cell B2, we need to

- Insert a function in cell
**B2**to display the current date from our system. This would be the function`=TODAY()`

. - Press
**Enter**.

This will show the current date in Google Sheets.

*Figure 7. Example of How to Insert Date in Google Sheets*

The date updates every time we open or recalculate the worksheet.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment