|
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
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 |
Date formula problem
Apologize, my bad, you did post again but in the same newsgroup
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "Peo Sjoblom" wrote in message ... 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 |
| All times are GMT +1. The time now is 08:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com