Unix Time Stamp?

[Mish]

What is forumual to convert a date (example: 8/6/09) to Unix Time Stamp?

 

[Pete_UK]

If your Excel date is in A1, put this in B1:

=(A1-DATE(1970,1,1))*24*60*60

Hope this helps.

Pete

 

[Ron Rosenfeld]

What is forumual to convert a date (example: 8/6/09) to Unix Time Stamp?

A Unix timestamp is the number of seconds since 1 Jan 1970 00:00:00 UTC

So to convert any particular date to Unix, you could use:

A1: date to be converted (UTC)

=(A1-DATE(1970,1,1))*86400

Format as General.

Of course, if your date input is in local time, and not UTC, you'd have to
add/subtract the difference from UTC to adjust it. So if local time is UTC - 4
hours, then:

=(A1+4/24-DATE(1970,1,1))*86400
--ron

 

[Mish]

Thanks! Worked Great!