Sorry for the topic title, I wasn’t sure how to describe this.
So what I have is a base of appointments, and I have ‘Date Appointed’ and "last Date of Appointment’ columns.
The third column, ‘Years Active’, is a calculated field that tells me the ye...