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
Thank you very much.
Thank you very much.