Frustratingly there's still no Max_Date() or Min_Date() function to use within formula fields. There is obviously Max() and a Min(), but ultimately they're designed for checking numbers and returning the largest or smallest, and not dates.
How does is solve the user problems?
Have a read through this and you'll get an idea of the users struggle. 4 years have passed, and I face this exact same issue again now.