Aug 04 2022 01:19 AM - edited Aug 04 2022 02:48 AM
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.
Aug 04 2022 01:39 AM
="Income Year: "&TEXT(B1,"mmmm yyy ")&"to "&TEXT(B2,"mmmm yyy")
This works in my sheet.
Aug 04 2022 02:52 AM
Aug 04 2022 03:24 AM - edited Aug 04 2022 03:26 AM
SolutionThat since you have "-" before second TEXT(). Just remove it
="Income Year: " & TEXT(B1,"mmmm yyyy") & " to " & TEXT(EDATE(B1,11),"mmmm yyyy")
Aug 04 2022 03:42 AM - edited Aug 04 2022 03:46 AM
@Sergei Baklan
"-" caused the problem.
Thanks a lot.
Aug 04 2022 03:24 AM - edited Aug 04 2022 03:26 AM
SolutionThat since you have "-" before second TEXT(). Just remove it
="Income Year: " & TEXT(B1,"mmmm yyyy") & " to " & TEXT(EDATE(B1,11),"mmmm yyyy")