Trying to use Vlookup to copy dates for a series of records (rows) from one
file to another. The result in the placed file (where the formula resides)
is 4 years and 1 day later than in the original/source file (or rather, 4
years with the leap day in included?). Have tried using text version of the
date and it appears in the placed file the same as the source file, but when
I change the format to date, the date increases as above. Both files are
(now) same version of Excel, though source file started out as 97-2003. Any
ideas?