Today vs. Yesterday sales difference

Today vs. Yesterday sales difference

Hi,

I have this table with (cumulative) sales by day:

DATE                  AMOUNT  
01/18/2013            11,750
01/14/2013            12,000
01/13/2013            11,500

I need to calculate automatically the difference by day so that the table would look like:

DATE                  AMOUNT      DIFFERENCE 
01/18/2013            11,750            -250
01/14/2013            12,000            +500
01/13/2013            11,500


PLS NOTE
11,750-12,000 = -250
12,000-11,500 = +500

I do not have a record every day. I need to take the latest record (by date) and subtract from it the second last record (by date).