INDEX MATCH but need to change return Values

[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

 

[Jacob Skaria]

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

 

[T. Valko]

Try this:

=--TEXT(your index formula here,"0000\/00\/00")

Format as Date