The issue I'm having is converting imported text in the format "Jul-21" to a date format excel recognizes as the 1st date of the month from the given text. For example, "Jul-21" should be "July 1, 2021".
When I try using the methods I've read online I get "July 21, 2019" or I can get it to text, but can't figure out how to convert it to a date.
I'm sure there is a simple method, but I can't figure it out. A worksheet with my attempt using "texttocolumns" and "datevalue" is attached.
Bookmarks