Find next entry date
I'm currently trying to figure a formula that would find the next entered date for specific tools from my Rental Out column to populate the Rental In column. We have a system that tracks the movement of our tools and I'd like to find the next date entered by specific tools to track the duration the tool was on certain sites.
For example, row 7 Hammer, the Rental In would be 02/07/21 which corresponds to the next entered date for the hammer. Row 6 Ladder, Rental In would be 23/06/21, row 5 Rental In would be 29/06/21, etc.
Help Article Resources
Check out the Formula Handbook template!