Hi everyone,

I'm creating a budget spreadsheet and want to display some summary information at the top, which would read, "Your lowest balance of $X.XX will occur on DATE." Dates are all listed in column A, and the balance for each day is listed in column F. My current formula is:

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

However, the date is displaying as its text format (e.g., 42643 instead of September 30, 2016). I can't figure out how to format that last bit of formula as a date, like how the balance is formatted as currency. Changing the format of the entire cell does not do anything.

Any suggestions?