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)
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)