conditional formatting based on proximity to date

[Guest]

I know that similar posts have been here before, sorry, but htis is a little
different. I need to conditioanally format a row if the anniverary date of
the person in that row is:

within 2 weeks of today OR the anniversary occured within the last week.

AND I need it for the following anniverary:
1 month
2 months
3 months
6 months
any annual anniverary.

Am I asking this to where it makes sense? Thanks,

Ron

 

[Bob Umlas]

Use this formula for the conditional formatting, assuming the date is in
column A: Select everything, enter:
=OR(DATE(YEAR($A1),MONTH($A1),DAY($A1))=DATE(YEAR(TODAY()),MONTH(TODAY())-1,
DAY(TODAY())),DATE(YEAR($A1),MONTH($A1),DAY($A1))=DATE(YEAR(TODAY()),MONTH(T
ODAY())-2,DAY(TODAY())),DATE(YEAR($A1),MONTH($A1),DAY($A1))=DATE(YEAR(TODAY(
)),MONTH(TODAY())-3,DAY(TODAY())),DATE(YEAR($A1),MONTH($A1),DAY($A1))=DATE(Y
EAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),DATE(2000,MONTH($A1),DAY($A1))=D
ATE(2000,MONTH(TODAY()),DAY(TODAY())),AND($A1<TODAY()+14,$A1>TODAY()-7))
Bob Umlas

 

[Guest]

Bob,

Thank you for this response. I know that I should know this but tell me the
significance of the "2000" in the formula ......())),DATE(2000,MONTH........

Thanks,

Ron