Tip of the Day | Friday September 19th, 2025
Discover new tools to get things done.
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 › Text › 9. Convert Text Dates to Usable Excel Dates...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©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.