so I'm trying to put a helper column in for the benefit of another function. On many sheets of my WB i have a date column where the date is entered and data for that row is subsequently entered. The date column is custom formatted so if i enter 1-8 it returns 01-AUG-13, this is fine. Now, for the benefit of another formula, in a hidden helper column i want to extract just the "AUG" part of the adjacent date cell. I tried using =MID(A2,4,3) but it returns a value of 87??? i tried to custom format but to no avail. any ideas???
Bookmarks