SOLVED

Text formula

Contributor

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.

 

Oliullah_Siddique_0-1659600864745.png

 

5 Replies

@Oliullah_Siddique 

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

This works in my sheet.

income year.JPG

@Quadruple_Pawn

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?
best response confirmed by Oliullah_Siddique (Contributor)
Solution

@Oliullah_Siddique 

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

image.png

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

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

@Quadruple_Pawn
Thank you very much.