As far as the date ranges go, begin by adding an autonumber field. This will automatically number records beginning at 1, and incrementing from there.
Add a formula field named {Sunday}
to calculate the Sunday date for your desired starting week. For example, if you wanted the first week to begin on Sunday, December 1, the {Sunday}
field formula would be:
DATEADD(DATETIME_PARSE("DEC 1, 2019", "MMM D, YYYY"), {Autonumber} - 1, "weeks")
Then add a {Saturday}
field to find the appropriate Saturday date for each week:
DATEADD(Sunday, 6, "days")
Finally, turn the primary field into a formula that shows both dates:
DATETIME_FORMAT(Sunday, "L") & " - " & DATETIME_FORMAT(Saturday, "L")
![06%20AM 06%20AM](/t5/image/serverpage/image-id/18263i885FAB0C629AA56B/image-size/large?v=v2&px=999)
Without knowing more about the source and nature of the user data that you’re trying to track, it’s tough to offer suggestions on the extra columns.