Formula to rank invoices based on status and date

[Javielin]

HELLO, I ALREADY HAD SPEND TO MUCH TIME TRYING TO FIND THIS FORMULA FOR MY OWN,
SO I DECIDED TO ELEVATE THIS TO THE EXPERTS.
IM LOOKING FOR A FORMULA TO RANK INVOICES BASED ON STATUS AND DATE.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]STATUS[/TD]
[TD="align: center"]DATE[/TD]
[TD="align: center"]RANK (must Be)[/TD]
[TD="align: center"]RANK FORMULA[/TD]
[/TR]
[TR]
[TD]PAID[/TD]
[TD]31-JAN-2019[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PAST DUE[/TD]
[TD]28-FEB-2019[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PAST DUE[/TD]
[TD]31-MAR-2019[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DUE TODAY[/TD]
[TD]30-ABR-2019[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CURRENT[/TD]
[TD]31-MAY-2019[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CURRENT[/TD]
[TD]30-JUN-2019[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 473"]
<tbody>[TR]
[TD]My arguments are the followings:[/TD]
[/TR]
[TR]
[TD]IF STATUS IS "PAID" RANK MUST BE THE LAST ONE[/TD]
[/TR]
[TR]
[TD]IF STATUS IS "PAST DUE" AND CELL DATE IS THE OLDEST FROM OTHER "PAST DUE" DATES, RANK FIRST[/TD]
[/TR]
[TR]
[TD]IF STATUS IS "DUE TODAY" AND THERE IS NOT ANY OTHER "PAST DUE", RANK FIRST[/TD]
[/TR]
[TR]
[TD]IF STATUS IS "CURRENT" AND THERE IS NOT ANY OTHER "PAST DUE", AND CURRENT DATE IS OLDEST FROM OTHER CURRENT, RANK FIRST[/TD]
[/TR]
</tbody>[/TABLE]


APRECIATE ANY HELP.
[TABLE="width: 476"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]