I need to create a new variable date with only the month and year.
1/1/2016 5:30:00 AM to Jan-16
This is answer in the previous post
=TEXT(A1,"mmmm - yy")
http://www.excelforum.com/excel-form...from-date.html
But when I try to sort my dates oldest to newest it does not work since Excel is not treating my date variable as a date.
Thank you in advance!
Marvin
Bookmarks