OS: MS XP
EXCEL: 2000

The only value in the database that represents a date is a number in the
format 20070107. This would be 01/01/07.

So:
20070130 = 01/30/2007
20070131 = 01/31/2007
20070201 = 02/01/2007

I need to link into this table using the Function VLookUp.
20070107, 17
20070108, 23
20070109, 15

The values returned would be 12, 23 and 15.

The dates are changing all the time and I use the Now() function to get the
date. I dont want to use a look-up table to cross-reference the date.

So how to I convert the Value returned by the Now() function into what I need.

Example:
Date Now() I need
01/30/2007 39112 20070130
01/31/2007 39113 20070131
02/01/2007 39114 20070201

How do I convert the value returned by Now() into what I need without a
cross refferance table? Ex: 39113 into 20070201.

Thanks in advance.

--
Richard