Formula required for date without changing the date format

Hi,

When i was mapping with the data to retrieve the date with index formula the format of date was changed as 38879 for Feb-01-08 and i have applied other method as Index() function and date , month and year to get the out put as 02/01/08 by concatenating all the three.

Please refer to the attachment and would be great if slove this problem

Hi,

Try this:

="Policy period:"&TEXT(INDEX(Project_Dump!A:A,MATCH(Summary!E7,Project_Dump!C:C,FALSE),1),"dd/mm/yyyy")&" - "&TEXT(INDEX(Project_Dump!B:B,MATCH(Summary!E7,Project_Dump!C:C,FALSE),1),"dd/mm/yyyy")