Help Please

[Linh Le]

Reaching out to the community for help. I really appreciate it. Thank you.

Is there a good formula to extract most recent departure date based on this data below? The list is non-continuous so each row is separate.

[1999-11-15 -- 2005-04-18] Patricia A. Bannan

[2005-04-18 -- 2007-05-31] Walter T. McCormick

[1998-01-22 -- 1998-06-19] Walter T. McCormick

[1998-06-19 -- 1999-01-01] Christopher P. Conkey

[1998-06-19 -- 2000-08-01] Judith A. Warners

[1999-01-01 -- 2001-05-31] Gary Pzegeo

[2001-04-01 -- 2006-06-30] Kevin D. Girts

[2001-04-01 -- 2007-05-31] Parham Behrooz

[2001-04-01 -- 2007-05-31] Robert A. Calhoun

[2001-12-31 -- 2007-05-31] Eric R. Harper

[2001-12-31 -- 2007-05-31] Mehmet Camurdan

[2001-12-31 -- 2007-05-31] Todd C. Kuimjian

[2006-07-01 -- 2007-05-31] Alex Perrin

[2006-07-01 -- 2007-05-31] Anthony Norris

[2006-07-01 -- 2007-05-31] Michael Lee

[2006-07-01 -- 2007-05-31] Peter Malcom Wilson

[2006-11-13 -- 2007-05-31] Bob Rowe

[2006-11-13 -- 2007-05-31] Christopher Y. Kauffman

[2006-11-13 -- 2007-05-31] Gary Pzegeo

[2006-11-13 -- 2007-05-31] Lisa Brown-Premo

[2007-06-01 -- ] Margaret D. Patel

[2019-04-01 -- ] Robert C. Junkin

[1996-02-01 -- 1997-09-01] Richard M. Cryan

[1997-02-01 -- 2004-03-01] Prescott B. Crocker

[2004-03-01 -- 2006-08-10] Dana E. Erikson

[2004-03-01 -- 2006-08-31] Edgardo Sternberg

[2004-05-03 -- 2007-05-31] Anthony Norris

[2004-05-03 -- 2007-05-31] Lisa Brown-Premo

[2004-05-03 -- 2007-05-31] Peter Malcom Wilson

[2006-08-11 -- 2007-05-31] Gary Pzegeo

[2006-09-01 -- 2007-05-31] Alex Perrin

[2006-09-01 -- 2007-05-31] Michael Lee

[2007-06-01 -- 2021-12-13] Margaret D. Patel

[2018-01-02 -- 2024-02-15] Kandarp Acharya

[2021-12-13 -- ] Petros N. Bocray

[2024-01-16 -- ] David Kowalske

[2008-04-07 -- 2009-11-29] Jeffrey Cucunato

[2008-04-07 -- 2009-11-29] Stuart Spodek

[2008-04-07 -- 2011-09-27] Robert M. Shearer

[2009-11-30 -- 2010-08-05] Curtis Y. Arledge

[2009-11-30 -- 2011-09-27] Kathleen M. Anderson

[2009-11-30 -- 2011-09-27] Matthew Marra

[2011-09-28 -- 2013-04-19] Michael C. Huebsch

[2011-11-28 -- ] Justin Christofel

[2011-11-28 -- 2013-11-27] Philip Brides

[2011-11-28 -- 2015-03-09] Lutz-Peter Wilke

[2011-11-28 -- 2023-04-05] Michael Fredericks

[2015-03-09 -- ] Alex Shingler

[2011-05-31 -- ] Jeffrey A. Geller

[2011-05-31 -- 2013-02-04] Neill Nuttall

[2011-05-31 -- 2013-05-30] Anne Lester

[2011-05-31 -- 2013-05-30] Michael Schoenhaut

[2011-05-31 -- 2013-05-30] Talib Sheikh

[2011-05-31 -- 2018-03-01] James Elliot

[2013-05-30 -- 2018-03-01] Jonathan M. Cummings

[2014-02-28 -- ] Grace Koo

[2014-12-09 -- ] Eric J. Bernbaum

[2020-11-02 -- ] Michael Feser

[2020-11-02 -- ] Philip Camporeale

[1996-05-01 -- 1999-07-16] Paul H. Drexler

[1996-05-01 -- 2000-09-01] John de Beer

[1996-05-01 -- 2002-09-30] Quentin Faulkner

[1996-05-01 -- 2021-03-01] Daniel J. Fuss

[1999-07-16 -- 2004-08-10] Alexander Lee Muromcew

[1999-07-16 -- 2004-10-01] Eswar C. Menon

[1999-07-16 -- 2004-10-01] John N. Tribolet

[2000-09-01 -- ] David W. Rolley

[2002-09-30 -- 2004-10-01] Robert Ix

[2004-10-01 -- 2011-05-01] Mark B. Baribeau

[2004-10-01 -- 2013-04-11] Warren N. Koontz

[2013-04-11 -- ] Eileen N. Riley

[2013-04-11 -- ] Lee M. Rosenbaum

[2021-03-01 -- ] Matthew J. Eagan

 

[Fluff]

As I just showed the formulae worked, I have un-marked my post as the solution.
You will need to mark one of the other posts.

 

[Asbestos_Jen]

this one has some promise, but unfortunately the departure date is random in all of the rows...

I meant that the end date needs to be located in the same place in each cell. It already takes into account that it may be in any cell from A:V.