And if I want to do a whole column I would put
=IF(A1.A50=TODAY()+60,"60+",IF(A1=TODAY()+30,"30 +","")) ? Thank you so
much for your help!

"Bob Phillips" wrote:

In adjacent column

=IF(A1=TODAY()+60,"60+",IF(A1=TODAY()+30,"30+"," "))

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Luey" wrote in message
...
How do I figure which in a column are 30+, 60+, etc over today's date?