Finding a date minus 1 year then giving the value in next column.

I have several columns but the first column has dates, the second is the number of units sold up to that date.  These dates are from last year.  I would like to find the number of units sold up to th...