If today is friday, I need to AutoFilter by Mondays date

[AlexH]

If today is Friday, I need to be able to have an IF statement that will filter by Monday, but if not I need it to autofilter by tomorrows date. What I have now only does tomorrow, using "=IF(J2=TODAY()+1,TRUE,FALSE)", then it filters by true to show tomorrows schedule. What I'm looking for is a way for it to say if today is Friday, then run =IF(J3=TODAY()+3,TRUE,FALSE), but if it is Monday-Thrusday, run the other if statement. Any suggestions?

 

[BigC]

Excel has a Weekday function that returns a 1-7 number to indicate the day of the week.
So if today is a Friday =Weekday(Today(),2) will return 5. (The 2 in the formula says to use Monday as day 1 rather than Sunday)

With this function you should be able to get what you want, something like:
=Today()+If(Weekday(Today(),2)=5,3,1)
Note that this will treat Sat & Sun the same as Mon-Thu. If you want something different for Sat-Sun you'll need to include another IF.

I also don't get how J2 & J3 come into your application, so you'll need to adapt this as required.

HTH

 

[AlexH]

Thank you very much. That works like a charm.