View Single Post
  #1   Report Post  
craigcsb
 
Posts: n/a
Default Compare dates (one cell not in date format)


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