software

=IF(TODAY()-A4lt;30,H4,quot;quot;)

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
www.officekb.com/Uwe/Forums.a...excel/200603/1

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

the misc group

www.cpearson.com/excel/newposte.htm

--

Regards,

Peo Sjoblom

nwexcelsolutions.com

quot;radbid via OfficeKB.comquot; lt;u20251@uwegt; wrote in message
news:5e099897ef70f@uwe...
gt; =IF(TODAY()-A4lt;30,H4,quot;quot;)
gt;
gt; The above formula copies H4 contents when A4 is 30 days less than today.
gt; However, today's date is 3/30/06, A4 is 2/28/06, and nothing happens.
gt; When
gt; today's date was 3/29/06, A4 was 2/27/06, nothing happened. I'm
gt; stumped -
gt; can you help? Thanks!
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...excel/200603/1
Your formula Reads if Todays date minus A4 is less than 30 then copy the
contents of H4, otherwise do nothing.

So if todays date is equal to or greater than 30 you will not copy the
contents of H4.

Try A4lt;=30

If A4 is Less than or equal to 30 then...
quot;radbid via OfficeKB.comquot; wrote:

gt; =IF(TODAY()-A4lt;30,H4,quot;quot;)
gt;
gt; The above formula copies H4 contents when A4 is 30 days less than today.
gt; However, today's date is 3/30/06, A4 is 2/28/06, and nothing happens. When
gt; today's date was 3/29/06, A4 was 2/27/06, nothing happened. I'm stumped -
gt; can you help? Thanks!
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...excel/200603/1
gt;

Thanks for the help.

radbid wrote:
gt;=IF(TODAY()-A4lt;30,H4,quot;quot;)
gt;
gt;The above formula copies H4 contents when A4 is 30 days less than today.
gt;However, today's date is 3/30/06, A4 is 2/28/06, and nothing happens. When
gt;today's date was 3/29/06, A4 was 2/27/06, nothing happened. I'm stumped -
gt;can you help? Thanks!

--
Message posted via www.officekb.com

Thanks for the help.

Stuart Peters wrote:
gt;Your formula Reads if Todays date minus A4 is less than 30 then copy the
gt;contents of H4, otherwise do nothing.
gt;
gt;So if todays date is equal to or greater than 30 you will not copy the
gt;contents of H4.
gt;
gt;Try A4lt;=30
gt;
gt;If A4 is Less than or equal to 30 then...
gt;
gt;gt; =IF(TODAY()-A4lt;30,H4,quot;quot;)
gt;gt;
gt;gt; The above formula copies H4 contents when A4 is 30 days less than today.
gt;gt; However, today's date is 3/30/06, A4 is 2/28/06, and nothing happens. When
gt;gt; today's date was 3/29/06, A4 was 2/27/06, nothing happened. I'm stumped -
gt;gt; can you help? Thanks!

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