Please don't post in more than one newsgroup, see answer in

the misc group

http://www.cpearson.com/excel/newposte.htm

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




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