Calculate Date Status

Hi, AMBP1973  As I can understand, that you want to calculate number of overdue document and compare with in various time point. If this is the case, I want to share my point of view.

You need 3 column in your table, document submission date, due date, and approval date. If any document approved after due date will be considered over due. You can use filter function to evaluate this as you have done already. 

Another case is, if any document not approved yet and current date passed the due date will be considered overdue.

Once you evaluate no of overdue document, then you can compare between various time point.

Hope this helps!!

If this solved your problem, please mark it as a solution!!