Days of Difference Between Requisition Created and Requisition Approval Requested
I am trying to figure out a way to calculate the difference in Days between Requisition Created and Requisition Approval Requested BY Req. Identifier when the following statements are true
1. Transaction Event Type equals to Requisition Created, Requisition Approval Requested
2. The earliest date of Requisition Created and the latest day of Approval Requested
Challenge: I don't know how to create a formula that could calculate the difference correctly while meeting two criterion.
Temporary Solution: I use MAX to sort out the latest date of "Approval Requested" in one column and MIN to sort out the "Created" date in a different column and do the calculation in Excel.