can anyone help with a formula to calculate rank based on dates? I have 3 fields, Column A Salesman, Column B Customer, and Column C DateSold. I want to rank each sold date (oldest to newest), by Salesman. So Salesman Joe Smith's 1st sale was the oldest datesold, and his 2nd is the next...