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?