I Need an ALL INCLUSIVE report

[Milz2020]

I have multiple clients with multiple assessments that need to be lined up. One has a 1 year renewal date, the others are all 6 month renewals. I want it to automatically update showing when the due date is getting close 30, 60, 90 days and when it is past due, 7, 14, and 21 days. I also have another column that needs to show the last services and anything more than 14 days prior to today is overdue. I am a basics person when it comes to formulas, but I am trying to learn how to set up my spreadsheets