Date Range Macro?

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

Hi Audreya,

I.m not sure about what you want...
Try use that formula in the cell H10

Please Login or Register  to view this content.