Where -0809 is the language ID for English and dddd tells Excel to covert the date to the full name of the day.

Excel text function date format not working. Firstly you need to highlight the cells having the. Display the Home tab of the ribbon. For this we need to supply the text date into the syntax of the DateValue function in double inverted commas.

3 Convert Date. So the first thing you will need to check when you encounter the VALUE. I dont know how to change the excel date settings and changing the date in the cells doesnt result in anything.

DateValue function in excel converts the dates which are there in text format into standard Short Date format available in excel. I used the following formula but it is not working as I expected what might be going wrong. Your dates are stored as text.

Select Data tab - Data Tools group - Text to Columns. Date serial numbers by Excel but rather as text. Error with a Date function is to verify if your Date and Time settings are supporting the Date format in the date_text argument.

Another possible way to display negative numbers as negative dates in Excel is using the TEXT function. Select the column Data Text to columns Next Next Date. These date formats only work if the end users PC is set to the language the document was created in which can lead to problems in certain situations.

In case you want to convert the current date to the text format you can use the Excel TEXT function in combination with the TODAY function that returns the current date for example. The formula I tried. There are a couple of ways you can approach this problem.