Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Reoccurring date period filter till a certain date of the week

Topic Labels: Formulas
Solved
Jump to Solution
357 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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

image

First, find the date of the next Monday.

image

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

image

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

Should work or at least it’s a start.

See Solution in Thread

2 Replies 2

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

image

First, find the date of the next Monday.

image

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

image

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.