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

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

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

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

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

=IF(TODAY()-A1<=181,A1,"")


"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

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

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

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

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