Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR 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
Source by support.google.com #
 
PREVIOUS NEXT
Tagged: #google #sheets #convert #string #date
ADD COMMENT
Topic
Name
9+2 =