You can do this with a formual

Put this in B2 for the date in A2
=IF(Today()-A2<181,A2,"") and copy down

You can also use Conditiona Formatting to highlight the dates in Col A
Choose FORMULA is and enter
=Today()-A2<181

"Aline" wrote:

I am looking for macro codes that will show the dates only if the date is
less than 181 days before today's date, e.g. today is 2008-11-25, 181 days
before today is 2008-05-28.

Date Date
2007-10-30
2008-05-28 2008-05-28
2008-02-22
2008-10-29 2008-10-29
2007-10-09
2008-04-09
2008-06-15 2008-06-15
2008-11-15 2008-11-15

Can anyone help?
--
Aline