I have tried to figure this out myself but I have had no luck. It seems simply enough, but perhaps not.
Here is what I'm trying to do.
If A1 = Today then I want a "1" in A2
If A1 = This week then I want a "0" in A2
If A1 = Any date other than today or this week then I want a "2" in A2
Thank you all in advance for the help.