Both codes should do that. If they are not working can you provide a sample with some data as depicted in the .jpg file?

Sub RandyLiposki()
Dim rcell As Range
For Each rcell In Range("H2:H" & ActiveSheet.UsedRange.Rows.Count + 1)
    If rcell.Value = "TODAY" Then
        rcell.Offset(, -1).Value = rcell.Offset(, -1).Value
    End If
Next rcell
End Sub