Modify A Formula

[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

 

[Douglas J. Steele]

Looks like you're working in Excel. This newsgroup is for questions about
Access, the database product that's part of Office Professional.

I'd suggest reposting to a newsgroup related to Excel.

 

[tgcali]

I'm sorry! Wrong board!

tgcali

Looks like you're working in Excel. This newsgroup is for questions about
Access, the database product that's part of Office Professional.

I'd suggest reposting to a newsgroup related to Excel.