CONCAT which includes Text in one cell and a date (in YYYY) format in the second source cell

[LeighMacKay7]

Hi, everyone.

I am trying to concatenate two cells, which are formatted differently.

> The first cell (GW2), is TEXT.
> The second cell (GX2) is a custom DATE in the format of "yyyy"
An example answer is: "Bachelor's Degree" in cell GW2, and the year "2014" in cell GX2.

When I use the concat or concatenate functions.
=CONCAT(GW2&", "&GX2)
It returns "Bachelor's Degree, 45789" How do I change the format of 45789 to just be 2014. in a single cell, I know I can go to Custom and change it to "yyyy". But in the concatenated cell, this doesn't seem to work.
When I want it to return "Bachelor's Degree, 2014".

Any advice/suggestions, would be welcome.

Thanks in advance
Leigh

 

[LeighMacKay7]

Don't worry everyone.

I have managed to figure it out.

Answer is as follows
=GW2&", "&TEXT(GX2,"yyyy")