Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have this formula: =IF(COUNTA($J2,M$1)<2,"",INDIRECT("'"&$J2&"'!"&M$1 )) I would like to modify it to only display results for dates that are no more than 5 days from the current date. If the date entered is a month ago, or tomorrow then count, if the date entered is next week, don't count. Make sense? Any suggestions or ideas? Thank you in advance for your help. Then forum is always very good and I appreciate the assistance I have received. tgcali |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modify a Formula | Excel Worksheet Functions | |||
Modify A Formula | Excel Worksheet Functions | |||
Modify Excel Formula | Excel Worksheet Functions | |||
Modify A formula | Excel Worksheet Functions | |||
Modify a formula | Excel Discussion (Misc queries) |