How to get the current date in Excel

The following article summarizes the commonly used ways to get the current date in Excel.

Method 1: Use the TODAY () function

Step 1: In the cell to get the current date value enter the command = TODAY () .

How to get the current date in Excel Picture 1

Step 2: Press Enter to get the results:

How to get the current date in Excel Picture 2

Step 3: Copy the formula for the remaining cells to get the result:

How to get the current date in Excel Picture 3

Method 2: Use the shortcut key combination Ctrl +;

Step 1: Place the cursor in the cell to enter the current date value.

How to get the current date in Excel Picture 4

Step 2: Press the key combination Ctrl + ; -> Current date value displayed.

How to get the current date in Excel Picture 5

Step 3: Similar to operating with the remaining cells to get results:

How to get the current date in Excel Picture 6

Method 3: Use a VBA statement.

Step 1: Press the key combination Alt + F11 to open VBA window. Enter the command as shown:

How to get the current date in Excel Picture 7

Step 2: Save the newly created VBA file and exit the VBA. During the process of saving will be notified you click OK . Continue to press Alt + F11 to open VBA window and enter the following code:

How to get the current date in Excel Picture 8

Note: In this worksheet, perform from line A3 to line A21.

Private Sub Worksheet_Change (ByVal Target As Range)
Dim C11 As Range
If Intersect (Target, [A2: A21]) Is Nothing Then Exit Sub
For Each C11 In Intersect (Target, [A2: A21])
If IsEmpty (C11) Then
C11 .Offset (, 1) .ClearContents
Else
C11.Offset (, 1) = Date
End If
Next
End Sub

Private Sub Worksheet_Change (ByVal Target As Range)
Dim Cll As Range
If Intersect (Target, [A2: A6000]) Is Nothing Then Exit Sub
For Each Cll In Intersect (Target, [A2: A6000])
If IsEmpty (Cll) Then
Cll .Offset (, 1) .ClearContents
Else
Cll.Offset (, 1) = Date
End If
Next
End Sub

Step 3: Finally, you exit VBA and go back to the excel file you want to create automatically. Here when you enter data in column A, the current date is automatically entered into the corresponding cell on column B. So, when you enter the item data, the date entered is the current date entered automatically. to the Import date column .

How to get the current date in Excel Picture 9

Note: You can change the scope of data entry by modifying statements in the event Change of Worksheet .

Above are the basic ways to enter current date in excel. Depending on the work you choose for yourself the most reasonable way.

Good luck!