find the next due date after today within a group in an Excel PivotTable
- by Dennis George
I have got a table set up in one sheet with "transactions". Each row contains a name of a vendor, the amount owed or paid depending on transaction type, and the due date/transaction date. Here is some simplified sample data:
Vendor Date Invoice Payment
Vendor A 6/30 $200
Vendor A 6/30 ($200)
Vendor B 7/5 …