Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Sum of dates within a week in a same record

Topic Labels: Dates & Timezones
315 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Desktop Screenshot 2022.01.25 - 23.40.31.60

Any clue ?

Thank you !

1 Reply 1

Found a solution, using many formulas per table.