EXCEL

google sheets convert string to date

# 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