View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Raj[_2_] Raj[_2_] is offline
external usenet poster
 
Posts: 150
Default Extracting dates from a String

Hi,

Cells in Column A have strings of the following type:
eg A1:
Billing for the period March 14 2009 to March 13 2010 - Order dated
April 01 2009
In B1 I want the date : 14-Mar-2009
In C1 I want the date: 13-Mar-2010
(to elaborate, only the first two dates in the string need to be
extracted, third and subsequent dates in the string to be ignored)

Thanks in advance for the help.

Regards,
Raj