| 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
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| date that updates itself daily, plus another formula please?? | Excel Worksheet Functions | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Value between 2 dates | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Hybrid Mode
