ParseDate (14 déc. 2018)

#1

Hi,

Any Idea to parse date when we've got in cell. A1 : 14 déc. 2018.
I think =parsedate(dd MMM yyyy) will be ok but no.

Regards

#2

This works, but will need to investigate how to solve the french letters. Might require a rewrite of the formula with an additional ' CultureInfo' parameter

#3

Hi,
Thansk for your answer.
Yes, that would be a good idea (in the meantime here is a solution =ParseDate(SUBSTITUE(A1;"é";"e");"dd MMM. yyyy")
but not very practical on a daily basis;)

#4

Solved it by adding additional argument:

Also notice I did not include a dot after MMM, this is because the default MMM format in french includes a dot (déc.).

Will release a new version in the coming one or two weeks. Let me know if you want to beta test and I can send you a build.

#5

Yes., of course