Forum Discussion

Life_is's avatar
Life_is
Copper Contributor
Dec 16, 2020
Solved

Highlighting an anniversary date for 30 days

I have applied this conditional formatting =(MONTH(TODAY())=MONTH(B5))*(DAY(TODAY())=DAY(B5)) and it works like a charm!! However, I cannot seem to figure out how to add in the formula for the cell(s...
excel
  • mtarler's avatar
    mtarler
    Dec 16, 2020

    Life_is there are lots of ways to do it, but how about:

    =(ABS(TODAY()-DATE(YEAR(TODAY()),MONTH(B5),DAY(B5))-15)<=15)

MindreVetande's avatar
MindreVetande
Iron Contributor
Dec 16, 2020

Life_is 

If you don't care if it stays on for ever

=TODAY()>=(B5-30)

Or, if you want +- 30 days

=ABS(TODAY()-B5)<=30

 

Or if you want the warning to go of once the date is passed

=AND(TODAY()>=(B5-30),TODAY()<=B5)

=(TODAY()>=(B5-30))*(TODAY()<=B5)

 

 

 

Life_is's avatar
Life_is
Copper Contributor
Dec 16, 2020

MindreVetande 

 

Thanks so much for your input!!! .. I really appreciate it!!!

Resources