Forum Discussion
Solved
Text formula
Hello,
In B4 following formula has been used:
="Income Year: "&TEXT(B1,"mmmm yyyy")&-TEXT(B2,"mmmm yyyy")
The result becomes number format i.e. 43983 (Cell B4).
I need the result as in Cell B6 i.e. Income Year: July 2019 to June 2020.
Thanks in advance.
That since you have "-" before second TEXT(). Just remove it
="Income Year: " & TEXT(B1,"mmmm yyyy") & " to " & TEXT(EDATE(B1,11),"mmmm yyyy")
5 Replies
="Income Year: "&TEXT(B1,"mmmm yyy ")&"to "&TEXT(B2,"mmmm yyy")This works in my sheet.
- OliverScheurich
Thank you very much. - OliverScheurich
I have attached my excel. Could it be any problem with my excel file?
In B2, I used the following formula:
=EDATE(B1,11)
Would you please see my excel?That since you have "-" before second TEXT(). Just remove it
="Income Year: " & TEXT(B1,"mmmm yyyy") & " to " & TEXT(EDATE(B1,11),"mmmm yyyy")
