![Avatar](https://success.clarizen.com/system/photos/617068728/face.jpg)
Hello Dennis,
A relations summary field should be able to this with static dates. However, you could replace static dates in the formula with custom date fields which could be updated daily by a scheduled workflow rule (i. e. dynamic dates).
Please let me know if this is helpful.
Thank you!