4 Simple Ways to Insert Current Date and Time in Spreadsheet

Kingsoft Spreadsheets has always been one of my favorite tools. I was an early adopter and it has always been the most reliable tool for me, and there are plenty of hidden features inside Kingsoft Spreadsheets you may be amazed to discover.

Here today I summarize 4 ways to insert date in spreadsheet. I'll explain them in details as following.

1. Use shortcut to insert date and time

Although you could enter the date and time directly in the cell, that’s not the quickest way I think. Here I’ll introduce the shortcut to do that:

“Ctrl”+”;” for current date

“Ctrl”+”’” for current time

If you would like to insert current date and time at the same time, you can check the formula way below.

2. Use formula to insert date and time

Note: Using the formula way you can real-time update the date. Only thing you need to do is using F9 to refresh it.

That means, if you plan to edit your document on a regular basis (to update the task statuses, for example), this is not going to be an issue using the formula way. However, in other ways unless you make any edits to the document, you are not going to see the current date and time.

Formula “=today()”

Formula ”=now()”



3. Enter other types of date

Use Ctrl+1 to open the Format Cells, choose Custom and enter the format you want in the Type, for example m"."d"."yyyy;@, then you can enter 3.25.2013 in the cell.



4. Set the date format

Like you did as front, you can set the date format in the Date option by opening the Format Cells.