| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup with date in Excel 2000 VBA
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup using concatenated values - Excel 2000 | Excel Worksheet Functions | |||
| What date is7 days from given date in Excel 2000 | Excel Discussion (Misc queries) | |||
| Vlookup using a reference to a named range?(Excel 2000) | Excel Discussion (Misc queries) | |||
| Vlookup problem with Access Query import into Excel 2000 | New Users to Excel | |||
| #VALUE! error: vlookup works in Excel 2000 but not 2003 | Excel Discussion (Misc queries) | |||
![Larry D[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
