Date is current. How to get current date and time in Excel

Microsoft's Excel program is a powerful processor that makes it easy for many users to work daily with large amounts of tabular data. However, even experienced specialists who have been working with this program for many years are sometimes lost before having to insert the current date and time into the worksheet cell. This is mainly due to the fact that the "Date" function, which would be logical to use to obtain the desired values, performs a completely different task. In this article, we will tell you about the different types of dates used in Excel, about how to get them and the features of their application.

date current




Date Types

Excel " ". – , . , . ? , , , . , .





" " - , , . – , " 14 2017 .". , , . , , , .

, Excel , : . , . , , . , .

, Excel .

,

Excel " " Ctrl ";". , Ctrl, . , 14.05.2017.

date and time




: Ctrl, Shift . . ":".

, , , .

, Excel . , , , .

,

Excel . :

  • "=()" .
  • "=()" .

Excel current date




, , , // .




All Articles