Date formula problem

[radbid via OfficeKB.com]

=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!

 

[Peo Sjoblom]

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

 

[Peo Sjoblom]

Apologize, my bad, you did post again but in the same newsgroup

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

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