The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.
Yes. Rollup provides function with field value of all linked records with possible filtering. Simple case, just link them on weekly basis instead of daily.