PDA

View Full Version : Solved: Date Formula With Conditional Formatting



Wolfgang
02-22-2007, 03:38 AM
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
02-22-2007, 03:59 AM
=DATE(YEAR(TODAY()),MONTH(C2),DAY(C2)-2)=TODAY()

Wolfgang
02-22-2007, 04:09 AM
Hi Bob...

THAT easy, huh?!

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

Best,
Wolfgang

Bob Phillips
02-22-2007, 04:33 AM
Are the Marzen Bier ready yet?

Wolfgang
02-22-2007, 04:39 AM
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...