Hi,

I'm trying to setup a formula like this.
=VLOOKUP(AA8,[filename_20070725.xls]base'!$A$1:$CJ$302,12,).
Everyday a new file is created with the date appended to it. And instead of
manually changing the filename in the formula everyday I would like to
somehow have the formula automatically increment the date by 1 everyday.

For example, if today is 7/26/07, then the formula should be:
=VLOOKUP(AA8,[filename_20070726.xls]base'!$A$1:$CJ$302,12,).

Any help is welcome. Thanks.