I have a list of clients ranked in descending order by their entry date into a program.
I need to find clients prior entry (if applicable). If client does not have a prior entry, I need the default date to be clients only entry date.
Client 143 most recent entry to program was on 2/28/2012. I need a way to mark or identify the clients previous entry prior to 2/28/2012 entry. In this case the clients entry date would be 11/23/2011. Prior-Entry.xlsx