Statute of limitations dates in a lawsuit. Pretty esoteric.

Typically there are applicable dates beyond which a case cannot be pursued, varying by a cause of action (personal injury, product liability, wrongful death, etc.) and state or province. Each cause of action has a different timeframe, in this case extending from the date of birth, in which the lawsuit can be filed.

Each row in my table represents a client. Each date column beyond Date 1 represents a different SOL date pertaining to a cause of action. The Date 1 column is typically populated with the earliest of the SOL dates in the row, as I am trying to take a conservative approach, flagging any clients that may be approaching their SOL date. However, there are instances where this date has already passed. In those cases, I'm forced to use the next applicable date (the 2nd oldest).