L
Legacy 465601
Guest
I have this spreadsheet and I need to build a formula to catch dates needed from a worksheet that has multiple dates and I need only the current and the one prior to the current Date.
I am using SSN # as my unique ID to vlookup the old and the new dates but some SSN’s have multiple dates and I don’t know how to catch only the current and the date prior to the current. Any suggestions will be appreciated!
I am using SSN # as my unique ID to vlookup the old and the new dates but some SSN’s have multiple dates and I don’t know how to catch only the current and the date prior to the current. Any suggestions will be appreciated!