Sorting the named range doesn't affect min & Max, as it might affect a Vlookup.I sorted the myDATES range I created in ascending, descending, and randomorders, and got the right answers every time.