Text formula

[Oliullah_Siddique]

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.

[#2]

@Oliullah_Siddique 

="Income Year: "&TEXT(B1,"mmmm yyy ")&"to "&TEXT(B2,"mmmm yyy")

This works in my sheet.

[#3]

@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?

[#4 · Accepted solution]

@Oliullah_Siddique 

That since you have "-" before second TEXT(). Just remove it

="Income Year: " & TEXT(B1,"mmmm yyyy") & " to " &  TEXT(EDATE(B1,11),"mmmm yyyy")

[#5]

@Sergei Baklan
"-" caused the problem.
Thanks a lot.

[#6]

@OliverScheurich
Thank you very much.