formula for conditional formatting and dates

[jocelzn]

What formula can I use in conditional formatting to change the color of cells if today's date is within 30 days of the date in the cell?

 

[Joe4]

Welcome to the Board!

If the date is in cell A1, maybe something like:

=A1-TODAY()<30

or

=TODAY()-A1<30

depending on which way you are going (it isn't quite clear from your question if you mean less than 30 days before or after).

 

[Joe4]

Note if you want to make sure it is positive, you may need to use AND and add a second condition, i.e.

=AND(A1-TODAY()>0,A1-TODAY()<30)