I am using Excel 2000 with Microsoft Windows 2000.

I would like to vlookup using a date in cell e2 which has the date
in this format: 02/12/07.

I would like to read the cell and subtract 7 so it is the previous
week
and format it mm-dd.

After that, I would like to concatenate the date with "Report for "
with the date ending I have just done.

How do I do it?