I need to create a formula that looks at two different date fields and produces the result as a check (or no check) in a checkbox field.
The two columns are: "Date Requested" and "Date Received." The expectation is that the "Date Received" will be 4-6 weeks after the "Date Requested." So basically, I need the box checked if the received date is less than 6 weeks from the requested date. Also, the box needs to remain unchecked if the "Date Received" field is blank.
Ultimately, we are trying to create a "scorecard" to measure the efficiency of our various suppliers. We will then need to filter by the supplier and calculate, by percentage, how well they are meeting expected delivery times.
Any takers? Any help is greatly appreciated.
Dan