Dates format

[ha95148]

My data has dates with wrong format.
It shows up in Excel as "19-Jan" which mean Jan 2019. But if I have the cursor on the cell, actual date shows "1/19/2018"
How do I reformat this so that the date reads "Jan 2019"
Thank you in advance.

 

[AlanY]

try format cell as custom mmm-yyyy

 

[ha95148]

when i format as custom mmm-yyyy, it reads "Jan-2018". It's supposed to be "Jan-2019"

 

[RasGhul]

=TEXT((A1+365),"mmm yyyy")

 

[ha95148]

Thanks, RasGhul, but it worked only for some, not others. Your formula converted it to "Jan 2019" while the date currently shows "20-Jan" in the file but actual date reads "1/20/2018".
This date is supposed to be "Jan 2020". I think my data is completely out of whack, maybe there's no hope to fix it

 

[RasGhul]

Ok ha95148

So if all cells that have 19-Jan in each cell, but excel thinks that this data is 1/19/2018, this worked for me;

[/COLOR]=TEXT(DATE((YEAR(A1)+1),MONTH(A1),1),"mmm yyyy")[COLOR=#333333]