Calculation for Approaching Due Dates
I am trying to create a calculation to tell when a vehicle's inspection is approaching, due and overdue. My problem is I don't know how to make my calculation decipher between the 3. I've tried a nested if function, but that returns all 3 values. Instead of showing one or the other, all 3 values come up if the function is equal to "overdue." Anyone have any tips on how to accomplish this?