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?

On Mar 22, 2:22 pm, "Larry D" wrote:
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?

Larry,

Search the Excel help for "VLOOKUP" and run through the examples. As
for formatting your dates, there are two options: (1) go to Menu Bar:
Format/Cells/Number tab. Then select the "Date" Category for the
format you want. (2) Select the "Custom" Category and create your
own. As for concatenating, search Excel help for "CONCATENATE" or use
the "&" sign (e.g. ="The Report for " & E2).

Your description is not very good, so hopefully my answer fits what
you asked.

Matt