How to convert a string to date?

in a excel i have 8 January 2018 as a string how can i convert it to date format.
ex- 8 January 2018
my result will be 2018-01-08.
how can i do this?

Cdate(Str).ToString(“yyyy-MM-dd”)

image

try this @arijit1213
Cheers

1 Like

Thank you.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.