=IF(TODAY()-A4<30,H4,"")

The above formula copies H4 contents when A4 is 30 days less than today.
However, today's date is 3/30/06, A4 is 2/28/06, and nothing happens. When
today's date was 3/29/06, A4 was 2/27/06, nothing happened. I'm stumped -
can you help? Thanks!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200603/1