All you need to do is to format the cell containing the VLOOKUP formula as a
date,
Regards,
Alan.
"Paul Dennis" wrote in message
...
I am using VLOOKUP to return a date, however it returns the number of the
date, rather than the date. I know that Excel stores dates as numbers,
hence
how do I get around this?