Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 ?

Thank you

share|improve this question
up vote 12 down vote accepted

I've actually figured this one out, here is the answer:

=(C2 - DATEVALUE("1/1/1970"))*86400

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .