INDEX MATCH but need to change return Values

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

Hi everyone,

Here is my drama. I am using an index & match and everything works fine. The
value that it is returning is correct but it is in the wrong format. It is a
date but displayed as 20090410 (yyyymmdd). I need it to return 10/04/2009
(dd/mm/yyyy).

Any ideas?

cheers

Sam
 
If the return value is a text string you can try the below...and format the
formula cell to a date format of your choice

=DATE(left(formula,4),mid(formula,5,2),right(formula,2))

If this post helps click Yes
 
Back
Top