I have a collections list which has three columns for notices. So a client, who hasn't paid a bill, will be notified three times before their account will be turned over to collections. I would like to create a calculated control that would determine the number of days that have passed from their most current notice. For example, Client A was first noticed on 02/01/2022 and then noticed the second time on 04/02/2022. Client B was first noticed on 03/30/2022. Client C was noticed first on 04/03/2022. I would like a calculated control that would determine the number of days from the LAST notification for each client. So client A it would be looking at the second notice date to today; client B would be looking at the first notice date to today and same for client C.
Any tips on how to create that calculated control? The # of days would always be determined from the last notice to today.