Question : google sheets convert string to date
Answered by : charlesalexandre-roy
# Basic syntax:
=DATEVALUE("7/20/1969")
=DATEVALUE("1969-7-20")
# Note:
# - the input to DATEVALUE must be a string
# - if the returned date looks odd (like 25404), that has to do with
# how Google represents dates internally. You can change how the
# date is displayed with format -> number -> date
Source : https://support.google.com/docs/answer/3093039?hl=en | Last Update : Sun, 17 Jul 22