Todays date is September 01, 2020. Part A A tool is calibrated on Jan 01, 2020. It has a 6 month calibration cycle so it is overdue by 3 months How to show actual calibration due date and -3 month overdue date in 2 separate cells. Part B As above, but tool has calibration cycle...
Running unique count of occurrence on table based on date Hello, I have a report that is extracted daily Mon-Fri. I want to show the unique ticket number (because sometimes is duplicated) that is overdue on the day I extract the report and how many day(s) that ticket has been in the...