how to show most current date in cell with multiple dates

I'm new and am trying to format one cell with multiple dates in to just show the most current date. Is there any way to do this? I am using office 365.

Annotation 2024-12-17 131049.png

You will have to split the cell into multiple cells and then determine which is the most current with normal excel functions. If you need assistance in how to split the cell, then post back.

Please note that you have not told us which version of Excel you are using. This will make a difference in how people here respond. Windows is your operating system. Some of the most recent versions of Excel are 2019, 2021, O365. Please update your profile to reflect the version you are using.

Originally Posted by naasej

I'm new and am trying to format one cell with multiple dates in to just show the most current date. Is there any way to do this? I am using office 365.

Attachment 885055

No, there isn't, at least not in the same cell. Easy enough to extract to another cell.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Using Power Query

Please Login or Register  to view this content.

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

Formula:

Formula:

Please Login or Register  to view this content.