VLOOKUP return text not date

P

Paul Dennis

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?
 
A

Alan

All you need to do is to format the cell containing the VLOOKUP formula as a
date,
Regards,
Alan.
 
R

Roger Govier

Hi Paul

Either
Format the cell returning the formula as your own choice of Date format
Format>Cells>Number>Custom> dd mmm yyyy for example
Or
If you are using the result of the Vlookup as part of some further text
string, then
=TEXT(your_vlookup_formula,"dd mmm yyyy")
 
Top