+ Reply to Thread
Results 1 to 3 of 3

Return latest Date from cell containing several dates?

  1. #1
    Forum Contributor
    Join Date
    02-09-2011
    Location
    Perth, Australia
    MS-Off Ver
    2016
    Posts
    161

    Return latest Date from cell containing several dates?

    Hi Forum,

    I recieve a spreadsheet from another company with their forcast and actual delivery dates for equipment parts.

    They often put multiple Actual Delivery dates in one cell (because a delivery ends up being split and arriving at different times). I can not get them to change the way they do this as they need to record all delivery dates and are not willing to change their system.

    I need to have just one date in each cell (the latest date) so I LatestDateOnly.xlsxalways have to go through the spreadsheet and manually delete the extra dates. The spreadsheet is around 7000 rows long so this is not a pleasant task!

    What I need is a formula, macro or VBA code that can automate this task for me. I have played around but can't seem to work out how to do this.

    Does anyone know how I could extract just the latest date from each cell so that I have one column of dates with just a single date in each row?

    I have attached a simple example. (I tried to but not sure if it has worked!)


    Thank very much

    Dave

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Return latest Date from cell containing several dates?

    Assuming dates are in column A as shows, and no other data exists so the columns to the right can be used for a quick TextToColumns>DateConversion, and that there are no more than 6 dates in one cell, this macro will do that.
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Return latest Date from cell containing several dates?

    THanks for the feedback.

    I have marked this thread solved for you.

    In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1