Date Range Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

audreya@officeformac.com - 29 Oct 2008 23:44 GMT

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,`)

Reply to this Message

JE McGimpsey - 30 Oct 2008 04:54 GMT

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 6 lines]
>
> =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, "")

Reply to this Message

Bob Greenblatt - 30 Oct 2008 12:23 GMT

On 10/29/08 6:44 PM, in article 59b5f52b.-1@webcrossing.caR9absDaxw,

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 6 lines]
>
> =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.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / October 2008

Date Range Macro