WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to insert dates in excel automatically

July 21, 2022
5.1K Views

The built-in Excel function TODAY() will enter the precise date of today and will display the most recent date each time the workbook is accessed. The current date and time may also be inserted using the built-in function NOW(), which will remain current even if the worksheet is opened more than once.

How to insert specific date in excel online, 2016 and 2019

1. To enter a specific valid date in Excel, we must utilise the DATE() function. The Year, Month, and Day values are requested by the DATE function in the aforementioned code, as can be seen. If we provide the information, the default date will be displayed as follows:

How to insert static date and time in excel

When a sheet is opened or recalculated, a static value stays the same. Follow the instructions below to do so:

1. Choose the cell in a table where the current date or time will be entered.

2. Pick one of these:

  • Insert the current date by pressing Ctrl+; (semi-colon).

  • Insert the current time by pressing Ctrl+Shift+; (semi-colon).

  • Insert the current date and time using Ctrl+; (semi-column), then hit Space, Ctrl+Shift+;, and (semi-colon).

  • Inserting a date in excel through a drop-down calendar

    If you build up a table for other users and want to ensure that the dates enter correctly, it could be a good idea to add a down calendar in your worksheet. The dates may be input with a single mouse click, and you can be certain that every date is typed correctly. When using a 32-bit version of Excel, you can utilise the MicrosoftWPS Date Picker feature. When using a 64-bit version of Excel 2016, Excel 20139, the WPS Date Picker Control will not function.

How to add an automatically updating current time and date in excel

Use one of the following Excel date functions to keep your date up to date today:

When use the Excel date functions, keep the following in mind

1. The chain will only be reopened or recalculated once, at which point the date and time returned will be updated.

2. The functions use the system clock's most recent date and time.

Note: This article was an attempt to make you understand how to add dates in excel online, 2016 and 2019, in both windows and mac. 

To get the newest version of WPS Office, you must first access this operating interface.

You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.