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

Modify a formula?
 

I forgot to add that M$1 refers to the date. Sorry about that!

"tgcali" wrote:

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

Modify a formula?
 

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))

--
Rick (MVP - Excel)


"tgcali" wrote in message
...
I forgot to add that M$1 refers to the date. Sorry about that!

"tgcali" wrote:

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

Modify a formula?
 

That's great. Thank you Rick.

"Rick Rothstein" wrote:

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))

--
Rick (MVP - Excel)


"tgcali" wrote in message
...
I forgot to add that M$1 refers to the date. Sorry about that!

"tgcali" wrote:

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