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?
|