I Need an ALL INCLUSIVE report

Milz2020

New Member
Joined
Aug 25, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,118,594
Messages
5,573,118
Members
412,504
Latest member
Confused exl
Top