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 () .
Step 2: Press Enter to get the results:
Step 3: Copy the formula for the remaining cells to get the result:
Method 2: Use the shortcut key combination Ctrl +;
Step 1: Place the cursor in the cell to enter the current date value.
Step 2: Press the key combination Ctrl + ; -> Current date value displayed.
Step 3: Similar to operating with the remaining cells to get results:
Method 3: Use a VBA statement.
Step 1: Press the key combination Alt + F11 to open VBA window. Enter the command as shown:
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:
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 .
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!