I'm having trouble getting a mid() formula to work inside of a concatenate formula.
I have a date in column A (mm/dd/yy) and I want to appear in column O as mm-dd-yy.
In column O I have the following formula, but I'm not getting the desired outcome.
=CONCATENATE(MONTH(A32), "-", DAY(A32)...