Hi Shane,

Thank you for asking. Yes, I was looking for macro codes.

Here is the code I have now:

..Range("E3:E" & LastRow).Formula _
= "=SUMIF('C1'!$A$2:$A$500, D3, 'C1'!$I$2:$I$500)"

The original date column is on the I column in the C1 sheet. What I wanted
was that only 2008-05-28, 2008-10-29, 2008-06-15 and 2008-11-15 will show up
on the E column of the active sheet.

Thank you so much for the function =IF(Today()-A2<181,A2,""). It works!

Hopefully you will be able to help me with macro codes.

Thanks,
Aline



--
Aline


"Shane Devenshire" wrote:

Hi,

Are you really looking for macro code or are you looking for a spreadsheet
formula? Because you are getting formulas not macro code as answers.

Thanks,
Shane

"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