Trying to do a filter base on a date

TLaGrant

I am capturing time and attendance. I have a field called Week Ending (Saturday) . I would like to to display the The previous week timecards for 5 days after the week ending date then I want the report to only show the new entries from that point until the 5 days past the end date repeating the cycle

Mike TV

@TLaGrant

You'll want to setup 2 filters with the OR between them like the screenshot above. The first one you'll select "is in the last (days)" and the other one you'll select "is in the next (days)".

If you need to exclude a day such as today, you'd set it up like this:

TLaGrant

Ended up with this ! TY

Mike TV

@TLaGrant

You'll want to setup 2 filters with the OR between them like the screenshot above. The first one you'll select "is in the last (days)" and the other one you'll select "is in the next (days)".

If you need to exclude a day such as today, you'd set it up like this:

Mike TV

@TLaGrant

If that doesn't work, you'll need to set up helper columns on your sheet which calculate the start date for the last 5 days and the end date for the last 5 days...then the same for the start/end dates of the next week. Then set up your filters to show what's between those date ranges.

TLaGrant

Ended up with this ! TY

vajara

Is there a reason these filter options wouldn't be an option?

That's my current case and I'm unsure why?