Get the latest 3 dates
I have a sheet with a status report date. Is there a way to search for the latest 3 dates?
Example: I want to return the rows for dates 11/06/20, 10/30/20, 10/23/20. But the dates could be any date values, just want to get latest 3.
I thought of trying to convert date to serial number and just max function, but don't see a way of converting the date to serial number like you can in excel.
Help Article Resources
Check out the Formula Handbook template!