Combined Month, Year and a text

[anneb_87]

Good Day Experts! I am combining the Month, Year and a text I am having an error

Formula I used: =TEXT(MONTH(D3),"MMMM")&" "&YEAR(D3)&" Update"

Written in D3: March 2021 or 03/01/2021

Expected Output: March 2021 Update

 

[Rick Rothstein]

You should not use the MONTH function inside the TEXT function... you want the physical date there and TEXT will parse it for you. Your modified formula should be...

=TEXT(D3,"MMMM")&" "&YEAR(D3)&" Update"

But since TEXT can parse dates, you can get it to give you both the month and year at the same time. Hence, your formula can be shortened to this...

=TEXT(D3,"MMMM YYYY")&" Update"

 

[anneb_87]

This works!!! Thanks!!