Text in formula
I want to display the sentence "Average Total Accounts: Oct - Apr"
based on a formula.
A23 = November-05
So far, I have the formula ="Average Total Accounts: "&TEXT(A23-1, "mmm")
which displays "Average Total Accounts: Oct", so I know I'm close.
Where I'm having a problem is adding the " - " between Oct and Apr and
adding the formula to display Apr.
|