returns the date-time serial number, from a date given as text.
DATEVALUE(datetext)
DATEVALUE("2007-11-23")