Modify a formula?

T

tgcali

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
 
R

Rick Rothstein

Is this what you are looking for (I wasn't clear on what you meant by
"modify")?

=IF(M$1-TODAY()>5,"",INDIRECT("'"&$J2&"'!"&M$1))
 
T

tgcali

That's great. Thank you Rick.

Rick Rothstein said:
Is this what you are looking for (I wasn't clear on what you meant by
"modify")?

=IF(M$1-TODAY()>5,"",INDIRECT("'"&$J2&"'!"&M$1))
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify A Formula 2
Display weeks from a Milestone 0
If Formula (visible cells only) 0
Expanding Date formula 2
Sum of Numbers of a Rolling 6 month Period range 0
Subtotal and IF Formula 1
CHANGE A FORMULA 0
counting weeks in current month. 1

Top