[TheNorm]

Try this:

=(A1-$F$1)*24*60*60

Column A has your dates, cell F1 contains the index date.

Using your examples, the number of seconds elapsed was as follows:

01/05/2008 1209600000
12/08/2009 1250035200