LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Modify a formula?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Modify a Formula carl Excel Worksheet Functions 1 August 25th 08 08:32 PM
Modify A Formula carl Excel Worksheet Functions 5 March 23rd 08 09:48 PM
Modify Excel Formula sharonm Excel Worksheet Functions 2 June 7th 06 02:46 AM
Modify A formula carl Excel Worksheet Functions 1 March 14th 06 05:46 PM
Modify a formula Eintsein_mc2 Excel Discussion (Misc queries) 3 September 18th 05 05:43 AM


All times are GMT +1. The time now is 10:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"