Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to retrieve date and time from computer in Excel?

When you edit a sheet, you may want to retrieve the current date and time from the computer to the cell. Actually, there are some easy ways that can quickly insert the current time and date in the cell in Excel, please go down for the details.

Retrieve date and time by shortcut key

Retrieve date and time by formula

Retrieve date and time by Insert Workbook Information good idea3

Enable you to do smarter, faster and better

Kutools - the best office productivity tool brings 300 advanced features to Excel. Details... Download...

Office Tab - brings tabbed interface to Excel and Word, make your work much easier. Details...Download...


Retrieve date and time by shortcut key


Here are some shortcuts for inserting current date and time in Windows and Mac systems.

In Windows systems

To insert current date, press

Ctrl + ;

To insert current time, press

Shift + Ctrl +;

To insert current date and current time,

Press Ctrl + ; first, then press Shift + Ctrl +;

In Mac system

To insert current date, press

Ctrl +;

To insert current time, press

Command + ;

To insert current date and time,

Press Ctrl +; first, then press Command +;


Retrieve date and time by formula

If you want to automatically update the insert date and time in Excel cell, you can apply formulas to insert current date and time.

Insert current date

Select a blank cell, type this formula =TODAY(), and press Enter key to get the current date.

doc retrieve date time 1 shot arrow right doc retrieve date time 2

Insert current date and time

Select a blank cell, type this formula =NOW(), and press Enter key to get the current date and time. See screenshot:

doc retrieve date time 3 shot arrow right doc retrieve date time 4

Retrieve date and time by Insert Workbook Information

If you want to retrieve date and time in a cell, a header or a footer, you can apply Kutools for Excel’s Insert Workbook Information utility to quickly insert information about workbook and sheet.

1. Click Enterprise > Workbook > Insert Workbook Information, see screenshot:
doc retrieve date time 5

2. In the Insert Workbook Information dialog, check the Current date and time option or other information in the Information section as you need, specify the location you want to insert at in the Insert at section. See screenshot:
doc retrieve date time 6

3. Click Ok. Then the workbook information has been inserted.



Excel Productivity Tools

Kutools for Excel - The Best Office Productivity Tool

  • Brings 300 powerful advanced features to Excel, enable you to do smarter, faster and better.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Office Tab - brings tabbed interface to Office, make your work much easier.

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.