Date formula problem
 

=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

Date formula problem
 

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

Date formula problem
 

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 A4<=30

If A4 is Less than or equal to 30 then...



"radbid via OfficeKB.com" wrote:

=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

Date formula problem
 

Thanks for the help.

radbid wrote:
=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 http://www.officekb.com

Date formula problem
 

Thanks for the help.

Stuart Peters wrote:
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 A4<=30

If A4 is Less than or equal to 30 then...

=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