CODEWITHSUNDEEP
excelms-office
Pointer
Pointer

Reputation: 2186

Write formula in excel 2013

How with formula in excel convert date 13.12.2016 to 2016-12-13

Any simple solution?

Upvotes: 1

Views: 31

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34285

It depends on your locale and whether it's a string or just an oddly formatted date.

The short answer is

=DATEVALUE(SUBSTITUTE(A1,".","/"))

or

=DATEVALUE(SUBSTITUTE(A1,".","-"))

and format the result as a date yyyy-mm-dd.

Upvotes: 2

Related Questions