I know how to get the max date but how do I get the date directly proceeding it? Some records will not have a date proceeding but 90% will have many. I want to creat formulas based on previous date and most recent max date and need to be able to handle it is there is no preceeding date.