Open Office Calc: Convert a date to timestamp

Question

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

Solution

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

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

Comments

[Timothy C. Quinn]

Thanks for this. Calc should have a an EPOCH() function for this =)

[Pavel Niedoba]

I don't see EPOCH in Libreoffice