Using the excel document attached. The "Job Start" and "Job Finish" columns are to be filtered to show dates that fall within the next 2/2-4 weeks of the selected "Period Date". So in the document, there are 6 jobs out of 10 that met the criteria of the filters.
The goal: Is there a way to use to automate the process of filtering the "Job Start" and "Job Finish" columns using the formula: WORKDAY.INTL(TODAY(),--(WEEKDAY(TODAY())<>6),"1111011") ??? Currently, we have to go in and manually select the dates within 4 weeks of the determined "Period Date" to get the jobs meeting the criteria. Is there a better way to do this? Thank you again!!
Clarification: I need the "Job Start" and "Job Finish" columns to be filtered to show dates within 4 weeks of the "Period Date" at the same time. The job needs to show if 1 of the 2 columns meets that criteria or both meet it.
Let me know if I can provide additional information! Thank you!!!
Bookmarks