| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trending Formula Results by Date | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| date that updates itself daily, plus another formula please?? | Excel Worksheet Functions | |||
| Value between 2 dates | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Linear Mode
