Split multiple dates values find MAX

  • Dear all,
    I have a column with multiple data values in each cell.
    Count of date values varies from 1 to 7 max.
    I need a code to retain only maximum of these date values in each cell and delete rest.


    Please note: Date values are separated with single spaces and colon as well.


    2016/05/25
    2016/05/25,2016/05/25
    2016/05/25 2016/05/25
    2016/05/25 2016/05/25
    2016/05/25 2016/05/25
    2016/05/24 2016/05/24 2016/05/24 2016/06/07,2016/06/07
    2016/04/28 2016/04/28 2016/05/12
    2016/04/28,2016/04/28
    2016/04/28,2016/04/28
    2016/04/28 2016/04/28


    Please help to improve my logic in these kind of cases.
    Thanks

  • Re: Split mutiple dates values in each cell and retain larger value only


    Here's the code and there's an attached file. :cool:


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!