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
Bookmarks