VBA Macro to Color Row Text If Date in Cell is greater than system date

Hoping someone can help me here, as this is uncharted territory for me.

I am hoping to write a Macro that checks If the date in any cell in column U is 6 months greater than the system date, it will color the entire row's text red.

I found this tidbit out there, and was hoping someone can skillfully re-purpose it to do what I described above. From what I saw this may be the answer to what I was looking for but I am not yet skillful enough to do this myself.

The Assumptions for this sample was:

If the date in column H matches the system date, then those rows will become green.
If the date in column H is the next date (tomorrow), those rows will become yellow.
If the date in column H is 2 to 6 days out, those rows will become blue.
If the date in column H is 7 to 13 days out, those rows will become orange.
If the date in column H is 14 to 20 days out, those rows will become red.
If the date in column H is 21 to 27 days out, those rows will become tan.
If the date in column H is equal to or greater than 28 days out, those rows will remain white.

Sub test2()
Dim LR As Long, i As Long
LR = Range("U" & Rows.Count).End(xlUp).Row
For i = 2 To LR
    With Range("U" & i)
        Select Case .Value - Date
            Case 0: .EntireRow.Interior.ColorIndex = 4
            Case 1: .EntireRow.Interior.ColorIndex = 6
            Case 2 To 6: .EntireRow.Interior.ColorIndex = 5
            Case 7 To 13: .EntireRow.Interior.ColorIndex = 45
            Case 14 To 20: .EntireRow.Interior.ColorIndex = 3
            Case 21 To 27: .EntireRow.Interior.ColorIndex = 53
       End Select
    End With
Next i
End Sub

I hope what I'm looking for is somewhere in there, but if not I am open to suggestions on other methods to research.

Thanks!

Sorry, to clarify, the code above was from an example I pulled that I thought might be close to what I needed, I may be completely wrong...

The dates in my spreadsheet in column U are in the date format seen in the image below.

Hopefully this clarifies, but again I only need one scenario which is to check the date in each cell in column U, if it's more than 6 months greater than the system date, color the row red text.

Date Image.jpg

Judge thank you so much. This was a huge help. Again, VBA was needed versus conditional formatting because of the way the data gets exported from a central system.

I tweaked yours slightly so that it colors the text red versus changing the fill color. And had to change the variable as I already had one for "i" defined earlier on in the larger macro.

    Dim LR As Long, P As Long
    
    LR = Range("U" & Rows.Count).End(xlUp).Row
    
    For P = 2 To LR
        With Range("U" & P)
            Select Case .Value - Date
                Case Is > 180
                    .EntireRow.Font.Color = RGB(255, 0, 0)
            End Select
        End With
    Next P