I've been reading around and there seem to be a lot of formulas to fix parts of my date problem but not sure how to combine them all to get a date that excel recognizes. Would like to remove the time, including the AM or PM and then convert the Month (Jan) into the date (1). Once that is out of there DATEVALUE should do the trick. Any ideas?
Thanks in advance for the help, this one has me stumped...
Bookmarks