Posted to microsoft.public.excel.worksheet.functions

Raj[_2_]

external usenet poster

Posts: 150

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting h:mm:ss from text string	Micki	Excel Worksheet Functions	19	January 26th 09 05:26 PM
extracting data from a string	Iguss	Excel Worksheet Functions	4	November 19th 07 09:50 PM
Extracting a string	Peter Rooney	Excel Discussion (Misc queries)	5	June 20th 06 06:34 PM
Extracting from a text string	AmyTaylor	Excel Worksheet Functions	3	June 24th 05 01:34 PM
extracting numbers from string	Chris Dowell via OfficeKB.com	Excel Discussion (Misc queries)	1	January 12th 05 09:37 PM

All times are GMT +1. The time now is 11:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us