TODAY()-02/28/06 = 30 so it is NOT <30 that's why, if you want to include 30
use

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"radbid via OfficeKB.com" <u20251@uwe wrote in message
news:5e0995f9f98df@uwe...
=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