Date Range Macro

[audreya]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm having trouble creating a macro. Here is what I need it to do. If the date on an item (listed in column E10) is less than 30 days from today, then put it in column H10. if not, do nothing. Here is the formula I made, but it does not work. Any tips?

=IF(10/28/08-E10<30,H10,`)

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm having trouble creating a macro. Here is what I need it to do. If the
date on an item (listed in column E10) is less than 30 days from today, then
put it in column H10. if not, do nothing. Here is the formula I made, but it
does not work. Any tips?

=IF(10/28/08-E10<30,H10,`)

XL08 doesn't support macros.

However, you don't need them. One way:

Put this formula in H10:

=IF((E10 - TODAY()) < 30, E10, "")

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm having trouble creating a macro. Here is what I need it to do. If the date
on an item (listed in column E10) is less than 30 days from today, then put it
in column H10. if not, do nothing. Here is the formula I made, but it does not
work. Any tips?

=IF(10/28/08-E10<30,H10,`)

Audrey,

JE's solution will work fine. However, you need to understand that a formula
can only produce a value for the cell it is in. It can NOT change the value
of another cell. Thus to get a result in H10, you need to put the formula in
H10.