Sum of dates within a week in a same record

Hello everyone,

I spent countless days trying to find a workaround with no joy.

My table has multiple records, which all have multiple dates filled in on a single line.

I’d like to find a way to count the number of dates just like a rollup would do, but only the dates that are within a week. My major issue is that even though I put filters in my rollup, the output which is a sum doesn’t take each date individually, but rather does the sum of every date of the record as soon as one date is within the scope.

Any clue ?

Thank you !

Found a solution, using many formulas per table.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.