How to find the latest (or earliest) date and a corresponding value Your email has been sent You probably know how to use the MAX() and MIN() functions, to return the latest and earliest dates, ...

How to Extract a Substring in Excel Using FIND() and MID() Functions Your email has been sent Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.