I have a column with dates in M/D/Y like this:
8/8/2007 8/9/2007 8/10/2007 8/13/2007 8/14/2007 8/15/2007 8/16/2007
I would like to convert them to a unix timestamp (in a new column). Would anyone know how I can do that ?
I've actually figured this one out, here is the answer:
=(C2 - DATEVALUE("1/1/1970"))*86400