logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Convert Text Dates to Usable Excel Dates...

ASAP Utilities  › Numbers & Dates  ›  15. Convert Text Dates to Usable Excel Dates...

This tool converts text-based date values in your selected cells into usable Excel dates that you can work with in formulas, sorting, or formatting. Sometimes, Excel does not recognize dates because they are stored as plain text.
These values are often left-aligned, cannot be formatted as dates, do not sort correctly, and will not work in calculations or with Excel date functions such as DATE, TEXT, DATEVALUE, YEAR, MONTH, DAY, EDATE, or DATEDIF. This might happen when data is imported or copied from other programs or due to differences in regional settings, such as the order of day, month, and year, different date separators (like slashes, dots, or hyphens), or months written out in another language. This tool helps you fix those issues by detecting the structure of each text date (for example, "JANUARY 23 24") and converting it into an actual Excel date (such as "23-01-2024"). You can:
  • Select the format your current text dates follow
  • Choose how to convert and format the recognized dates (for example, "23-01-2024" or "01/23/2024")
  • Apply Excel's date formatting or convert them to text in lowercase, uppercase, or title case
  • Skip the first row if it contains headers Your last used settings are remembered automatically. Note:
    The tool works best when all values follow a consistent date structure.

    Screenshots

    Numbers & Dates  ›  15 Convert Text Dates to Usable Excel Dates...

    Starting this tool


    Numbers & Dates  ›  15 Convert Text Dates to Usable Excel Dates...
    Additional keywords for this tool:
    Convert text to date in Excel, Convert text date to real date, Text not recognized as date, Fix unrecognized dates in Excel, DATEVALUE not working, Convert string to date, Change date format from US to EU, Excel dates stored as text, DATE function error, Use DATEDIF with text dates, Convert imported text to date, Recognize date format, TEXT function and date issues, Excel date functions not working, Regional date format problem, Fix date import errors, Convert text to usable date for formulas



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.