Have a look at the DateValue function.
--
Damon Longworth
2006 East Coast Excel User Conference
April 19/21st, 2006
Holiday Inn, Boardwalk
Atlantic City, New Jersey
Early Bird Registration Now Open!!
www.ExcelUserConference.com
2006 UK Excel User Conference
Summer, 2006
London, England
"thekovinc" wrote
in message ...
Hello. I am currently having a problem with text/dates. I am importing
data from another file that is completely text formatted. Some of the
columns in this file contain dates in the form of "Jan-01-06," and it
is always "MMM-DD-YY."
I am trying to find the difference between two of these dates, but it
will not work because of the text formatting.
ie. A formula that would output the difference between Jan-16-06 and
Jan-12-06 (the answer would be 4 days).
I am wondering if there is any easy way to convert them to dates
(changing format does not work). I have thought about just using the
LEFT command to grab the middle two numbers for the date, but that does
not take into consideration month or year changes.
Please let me know if you can help. Thanks in advance!
Nick
--
thekovinc
------------------------------------------------------------------------
thekovinc's Profile:
http://www.excelforum.com/member.php...o&userid=29378
View this thread:
http://www.excelforum.com/showthread...hreadid=512340