Reply To: DATEVALUE doesn’t work anymore

If it helps, you can use the SUBSTITUE function to clean up your text string before giving it to the DATEVALUE function, something like this:

=DATEVALUE(SUBSTITUTE("dd.mm.yyyy.";".";"";3))

Br,

• This reply was modified 8 months ago by administrator@dailyexcel.net.