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 ...
That since you have "-" before second TEXT(). Just remove it
="Income Year: " & TEXT(B1,"mmmm yyyy") & " to " & TEXT(EDATE(B1,11),"mmmm yyyy")
="Income Year: "&TEXT(B1,"mmmm yyy ")&"to "&TEXT(B2,"mmmm yyy")This works in my sheet.
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?
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")SergeiBaklan
"-" caused the problem.
Thanks a lot.