Try:
Formula: copy to clipboard

="Your lowest balance of " & dollar(min(F:F)) & " will occur on " & FORMAT(index(A:A,match(min(F:F),F:F,0)),"mm/dd/yy") & "."