Solved: Date Formula With Conditional Formatting

[Wolfgang]

Hi All?

I have these two formulas which I use with Conditional Formatting to show who?s birthday is today and/or was yesterday?

What formula do I have to use in order to show who is going to have their birthday the day after tomorrow with respect to today?s date?

Thank you very much?

Best,
Wolfgang

=AND(MONTH(C2)=MONTH(TODAY()),DAY(C2)=DAY(TODAY()))

=AND(TODAY()-DATE(YEAR(TODAY()),MONTH(C2),DAY(C2))<2,TODAY()-DATE(YEAR(TODAY()),MONTH(C2),DAY(C2))>0)

[Bob Phillips]

=DATE(YEAR(TODAY()),MONTH(C2),DAY(C2)-2)=TODAY()

[Wolfgang]

Hi Bob...

THAT easy, huh?!

Many thanks and have a beer on me during lunch...

Best,
Wolfgang

[Bob Phillips]

Are the Marzen Bier ready yet?

[Wolfgang]

YEEEEEAHHHH....

Since Monday until Easter...

Terrific stuff...I think I should have some of those before I start asking another Excel question...the answer lies within...

Take care...