Macro that changes a cell when another one has a date populated in it.

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

Oh! I forgot that part, I was using the word TEST to make sure that the macro would work. But now I need it to see the date like written above. Sorry!

I am still looking for an answer on this, my boss would really like this to be done tomorrow! Thank you all so much!

Thank you so much! I am learning this new stuff little bits at a time!