Date value not converting properly.
Cell B3 of main sheet has combined string of period abbreviation and date. I used a Right method to get the date out of the string. Its extracting the date value but when the date value is formatted back to date, its showing incorrectly. Like 2011 is showing as 2012.
Where the issue? Copy-of-dateExtraction201.xlsx