Using a Formula in Report Builder for "When"
I have multiple sheets containing employee's start dates on various projects. I want to build a report that draws from these sheets, but only displays the employees starting this Monday - with that date changing depending on when the report is viewed and what the upcoming Monday's date is.
Is there a formula or logic I can use in the "set criteria for" window, perhaps using "is equal to" and then inserting a formula to determine the next Monday?
If there's an easier way to accomplish this, please let me know. Thanks!