Format Index Match as Date When Combining Formulas

[RelativeRisk]

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?

[TMS]

Try:

Please Login or Register  to view this content.

[newdoverman]

I think that TMS meant "Text" instead of "Format" (a typo I'm pretty sure)

Please Login or Register  to view this content.

[TMS]

Oops, thanks, yes, TEXT. Senior moment and on iPad so not tested. Thanks again.

[newdoverman]

You're welcome.
You wrote an answer from an iPad! I'm impressed, they don't work very well for me at all...something to do with my chemistry. I have my share of "senior moments" too.

[TMS]

Yes, copying and pasting code and formulae is often a challenge. And solutions not always tested.