Conditional Formatting

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.

Sincerely,

Shannon

This isn't conditional formatting, it's just a regular logic expression.

At any rate, put this in cell A2:

Please Login or Register  to view this content.

Note this is "week starting on Sundays"; I assumed that's what you want 'cause it's kind of the default, but if it isn't, change the second term on those WEEKNUM expressions appropriately.

I also wrapped a year-check in with the "which week" check so that, for example, if it's the same week in a different year, that will also throw it out.

MarvinP,

Thanks for your help. Please see the attached. What am I doing wrong? Test.xls

The value will not appear once I have entered the formula. Perhaps my brain is fried.

Thanks again.

Shannon