Mr Excel & excelisfun Trick 180: Extract Varying Dates From Description

4,925 views · Published 14 April 2017 · 14:48 · Indexed 30 October 2026

Channel: excelisfun · 2017 · Education

Watch on YouTube

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick180.xlsm

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Bill Mr Excel Jelen and Mike excelisfun Girvin show how to use formulas to extract dates that are inconsistent in form (some are listed as Month and Year, some are listed as Day, Month and Year) from a text description. See the functions: SEARCH, AGGREGATE, MID, ISNUMBER, IF, TRIM and SUBSTITUTE. Learn about a Function Argument Array Operation. This is an Array Formula.

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,560 views · 23 May 2008

• 3:44 YouTubersLoveExcel#26: Text To Column Trouble

  excelisfun

  3,596 views · 30 May 2008

• 3:41 YouTubersLoveExcel#26.2: Formulas do not like TEXT Time

  excelisfun

  2,016 views · 6 June 2008

• 3:30 YouTubersLoveExcel#34: Hide Columns Copy Problem

  excelisfun

  3,877 views · 11 June 2008

• 9:27 YouTubersLoveExcel#31: Dates, Cash Flow & Logic

  excelisfun

  4,909 views · 11 June 2008

• 1:57 YouTubersLoveExcel#36: VLOOKUP increase based on Rating

  excelisfun

  3,053 views · 16 June 2008

• 7:38 YouTubersLoveExcel#52: VLOOKUP & Workbook References

  excelisfun

  3,914 views · 7 July 2008

• 1:39 YTLE#60: Hide Columns by Grouping

  excelisfun

  4,807 views · 18 July 2008