I have a column with dates in M/D/Y like this:
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
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
By posting your answer, you agree to the
terms of service.
9 months ago