I have a cell in general format with dates looking like this: Tue, Oct 26, 2010 and want excel to recognize it as a date. How do I do that? Thanks!
I need to frequently update the original data and would therefore like a formula that translates the text into a date rather than simply changing format... Thanks again
Thanks for the inputs, C Masters. This is close to what I have tried and I know it's pretty much what I'm looking for. However, I always get a #Value error.
I assume this is because of the three letter month name (e.g. Oct ) instead of number.
Does somebody know how to fix this?