How can I reference a row on another sheet in the same document and display the most recent past date in one cell, and the next future date in that row in another cell?
On a different sheet sheet named "Recertification Dates" I need to scan cells G2 : BQ2 and display
the Most Recent Past Date
the Next Future Date
This will be repeated on additional lines beyond line 2.
See attached file, and look at the sheet titled "Desired New Sheet" to see a visual explanation.
I'm wanting to improve a spreadsheet I've made for our Hospice office by cleaning up the display of info and make it more user friendly. I'd like to only show the start and end dates of the certification period a patient is in.