Forum Discussion
Excel Formula for Date and Time
Good Morning!! I need a cell to show the date and time that another cell was updated. I know how to use the =NOW() formula, but how do you get it to update everytime the adjacent cell is updated? See...
What i meant to say was that i am trying to get a date and time to show up in a cell when another cell is updated. For example if I input data into B6, i want C6 to show the date and time that data had been entered into B6. Specifically for unit sign-in and sign-out. Thank you for any help you can give:)
You need VBA for that.
Right-click the sheet tab.
Select 'View Code' from the context menu.
Copy the following code into the worksheet module.
Change the range as needed.
Switch back to Excel.
Save the workbook as a macro-enabled workbook (*.xlsm).
Make sure that you allow macros when you open it.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim MyRange As Range
Set MyRange = Range("B2:B100")
If Not Intersect(MyRange, Target) Is Nothing Then
Application.ScreenUpdating = False
Application.EnableEvents = False
Intersect(MyRange, Target).Offset(0, 1).Value = Now
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub