Reoccurring date period filter till a certain date of the week

Question

Hello Everyone,
I would like to create a formula that defines a range of dates depending on the due date within next Monday: as follows
filter content that due date is coming on till next Mondy only then resets again on Tuesday and shows me what is coming till next Monday.
Thank you Guys

augmented · Accepted Answer

I did it like this. I added two columns, though you could consolidate wherever you want.

First, find the date of the next Monday.

Then, calculate the number of days from the due date to the next Monday.

Filter on {Days Before Due} where it is >=0 and < 7.

Should work or at least it’s a start.

Thanks @augmented, That was a start, but it solved my problem entirely. appreciate it.

Ahmed_Elagami · Answer

I did it like this. I added two columns, though you could consolidate wherever you want.

First, find the date of the next Monday.

Then, calculate the number of days from the due date to the next Monday.

Filter on {Days Before Due} where it is >=0 and < 7.

Should work or at least it’s a start.

Thanks @augmented, That was a start, but it solved my problem entirely. appreciate it.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded