show the date when it is later than today's date

A

Aline

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

Sheeloo

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
 
S

Shane Devenshire

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
 
A

Aline

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top