How to flag the second largest date in a sheet
I have a sheet that collects responses from a form, specifically collecting status. I pull this data in to a second sheet to be able to show current and previous status on the same line. To do this, I am creating a helper column to flag the second largest date. I know how to find the most recent entry (largest date) using a combo of MAX and COLLECT, but the LARGE formula (=LARGE([Date number]:[Date number], 2)) has not been successful for me, to find the second largest date (in order to record previous status).
Does anyone have a way to find the second largest date?
Picture of headings here for context. The "date number" column is my attempt to format the date as a text/number in order to make the LARGE formula work. My assumption is that the column formula (which I need because this is a form) is messing with the formatting.
Help Article Resources
Check out the Formula Handbook template!