Hello team,
I need some help wiht an if then statement.
I have tried something but it's not showing any results when I run my macro, so something must be amiss....
This is what i have come up with so far:
'CountryA orders marked comments to ship expedite if today's date is between the 20th and 30th of the month. Range("X2").Select For i = 2 To x If Range("G" & i).Value = "CountryA" Then If Day(Cells(i, "AA").Value) < 31 Then If Day(Cells(i, "AA").Value) > 20 Then If Range("X" & i).Value = "" Then Range("X" & i).Value = "Please use Fast shipping." End If End If End If End If ActiveCell.Offset(1, 0).Select Next i
Note:
- AA = today's date
- G = country name
Bookmarks