Hello,

I have an excel that has a date column and a days out column. What I am looking for is when the date column has the date inserted in it, the macro changes the 'days out cell next to it, to the word done.

I have this working except for a small portion. The macro doesn't recognize the date format.

I have a time stamp that people will use that uses the formula =NOW() and has the format mm/dd/yy, hh:mm:ss. This formula doesn't see that???

I am now very confused!

Here is the macro so far:
Private Sub Workbook_Open()
Dim LastRow As Long
Dim i As Long
LastRow = Range("J" & Rows.Count).End(xlUp).Row
For i = 4 To LastRow
If Range("J" & i).Value = "TEST" Then
Range("K" & i).Value = "DONE"
End If
Next i
End Sub