| 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 |
| 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 | |||
Threaded Mode
