date function or text function recommended? to display mmm-yy when year is cell A1

I'm moving a table from a sheet that represented the current year, to a sheet representing a specific year. Each column title was a month. I'm wanting the new sheets column titles to be in the format of mmm-yy where the year is pulled from cell A1. Not really sure what the problem is as using each one of these formulas comes up with a different result... Please advise.

The column titles are in U6-AF6
Each example below A1 = 2020 and should display JAN-20

=DATE(1,1,$A$1) < - displays Jul-06
=CONCATENATE("Jan-",TEXT($A$1,"yy")) < - displays Jan-05
=CONCATENATE("Jan-",($A$1)) < - displays Jan-2020


What am I doing wrong? Should i use the DATEVALUE function?

Thanks
Murph

What you need to understand about dates and times in excel is…

a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Sat 27 Jun 2020) is actually 44009

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

DATE() needs year 1st, then month then day

Happy to help