"Dates" issue with US settings versus Dutch settings

Ok so my windows has Dutch regional settings, some of my colleagues have US settings.
Following should work in either situation.

Please see excel attached.
There is a column (A) with date time and AM/PM CET setup.

I need to lose the CET (with replace that is easy) so excel will see the field as a normal date field.

However after this (see column D) the lines with Feb nicely go to a "8-2-2019" format, however for me the line with 11-Mar-2019 will not convert as month 3 would not be Mar but Mrt in my settings.

How can I get this to work without regional settings being an issue?
Thanks.

Hi Richard thanks.
Formula seems to work (if you look with the wizard) but still no output (#Value) also when I customize the formatting of the cell to what you suggest.

However I would like to have a VBA solution for this as it is a part of a bigger macro

Sure now problem I will upload it with your formula in it.
It works for the Feb months not for Mar.

Please note the timevalue part would not be necessary.
Focus is only on the date part.
Just want simple dates.

This gives indeed a date converted to numbers

But (sorry) now the Month is first in the cell 3-11-2019. Can we change it so the day will come first? 11-3-2019

Ok think the formula is not working correct.
Added some dates where the day is higher then 12 (months in a year) and then he does do strange things (see file)

Thanks dotchiejack.
But the formula already gives the wrongs date.

See 18-Mar-2019 it makes 3-6-2020, so then running your macro maybe would change the order but it would still be the wrong date.

Went for a walk and when back dissected your initial formula Richard.
And was able to swap month with day

Think this will do the trick in the rest of my macro.
Thanks!