If the month is always three letters and the day is always 2 digits, uses a
helper column and enter
=MID(A1,5,3)&" "&RIGHT(A1,2)&" "&LEFT(A1,4)
Copy down to the end of the data
copy this column and paste special values on top of itself
Select this column
<Data<Text to Column next-next Select date
The input data is now in date format.

"craigcsb" wrote:


Hi all,

I have one column of cells in date format (6/14/2005) and another
column of cells which also contains a date pulled from a database but
this second column is not in date format, it comes from the database
like this 2005Jan20. I need to compare the two dates to work out the
number of days between the dates but I can't convert the second date to
date format.

Is there any way I can work out the number of days between the two
dates?

Thanks in advance
Craig


--
craigcsb
------------------------------------------------------------------------
craigcsb's Profile: http://www.excelforum.com/member.php...o&userid=24710
View this thread: http://www.excelforum.com/showthread...hreadid=382752