This will convert a textual date into a number which you can then format to appear as a date.

Text formula excel date not working. So when performing date calculations in Excel youd better supply dates using the DATE function to ensure the correct results. I think the problem with date format in regional settings. Where A1 contains an unrecognized date.

Actually I have seen this formula working fine in the past. Unlike the Text to Columns wizard it allows you to convert Excel date to text in any format of your choosing. Originally Posted by nflsales.

When it comes to working with dates in Excel DATE is the most essential function to understand. Now in the Find what field put a decimal and in the replace field put a forward slash. At first press the Window R button to open the Run dialog box.

Month formula not working correctly in Excel. Go to Formulas tab click on Error Checking drop-down arrow place cursor on Cell references now you will see error range s Second now you know the circular references range go to each error. Another quick no-formula way to turn Excel dates into text strings is using Notepad or any other text editor.

Text to columns to fix dates. Dd-mm-yyyy the date is in B5. From your keyboard press CTRLH This will open the find and replace dialog box on your screen.

Choose the dates in which you are getting the Excel not recognizing date format issue. Month is returning January when it is clearly February. The point is that other Excel date functions not always can recognize dates entered in the text format.