Hi Everyone ..
I am using the code below to auto input a date once another cell has had a value entered into it.
However .. the code seems to display the date WITH the time.
I have formatted the cells, but if you place your cursor in the cell, the value is the date & the time.
How do I populate cell 'C' with the date only in the format I have specified WITHOUT the time when cell 'B' has a value entered.
' 'Calculating Date & Time for File Allocation Column B to Column C ' ActiveSheet.unprotect With Target If .Count > 1 Then Exit Sub If Not Intersect(Range("B5:B605"), .Cells) Is Nothing Then Application.EnableEvents = False If IsEmpty(.Value) Then .Offset(0, 1).ClearContents Else With .Offset(0, 1) .NumberFormat = "dd mmm yy" .Value = Now End With End If Application.EnableEvents = True End If End With ActiveSheet.protect