The ASAP Utilities menu in Excel (English)
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:
The tool works best when all values follow a consistent date structure.
Screenshots
Starting this tool
- Click ASAP Utilities › Numbers & Dates › 15. Convert Text Dates to Usable Excel Dates...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
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
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
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Insert Unique Random Numbers |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 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.
🏆 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.