Text in formula
="Average Total Accounts: "&TEXT(A23-1, "mmm")&" -
"&TEXT(DATE(YEAR(A23),MONTH(A23)+5,1),"mmm")
--
Kind regards,
Niek Otten
"StephanieH" wrote in message
...
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.
|