Thread: extract date from text
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default extract date from text

=DATEVALUE(RIGHT(SUBSTITUTE(A1,"th",""),16))

I'm assuming that the date in A1 can vary, so hard coding the "th" and
the 16 won't work. A1 can have different ordinal suffices and month
names different in length than "November".

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Fri, 28 Nov 2008 09:59:01 -0800, Gary''s Student
wrote:

=DATEVALUE(RIGHT(SUBSTITUTE(A1,"th",""),16))
Reply With QuoteReply With Quote