Dear Experts,
Looks simple though but cant find a way to convert ‘Jan-12 to 2012 using any of the following
‘Jan-12 is in cell A1 and formulas are in cell B1 through B4
Attached, please find the excel sheet for quick reference.![]()
=TEXT(A1,"YYYY") gives 2013 =YEAR(A1) gives 2013 =TEXT(DATEVALUE(A1),"YYYY") gives 2013 =DATE(A1,0,0) gives 30-Nov
Best Regards/VKS
Bookmarks