What formula would I use if I wanted to format a cell (say in red) if the
date entered in that cell is 30 days or less from today's date?

Try:
=AND(A10<TODAY(),A10=TODAY()-30)


"CClark" wrote:

What formula would I use if I wanted to format a cell (say in red) if the
date entered in that cell is 30 days or less from today's date?

Suppose that cell is A2, then you would use this formula:

=AND(A2TODAY(),A2<TODAY()+31)

So if A2 is after today AND less than 31 days hence, then the CF will
be activated - I think that is what you meant.

Hope this helps.

Pete

On Feb 26, 6:57*pm, CClark wrote:
What formula would I use if I wanted to format a cell (say in red) if the
date entered in that cell is 30 days or less from today's date?

If the cell you're on is, say, A1:
=A1<=TODAY()+30
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"CClark" wrote:

What formula would I use if I wanted to format a cell (say in red) if the
date entered in that cell is 30 days or less from today's date?