INDEX MATCH-result from date number to short date

[Bravo33]

Morning, Been trying to convert a MATCH INDEX result from date number to short date.
The formula I have so far which does not quite work

="ENQUIRY"&-INDEX(B3:B17,MATCH($A$1,A3:A17,0))

 

[steve the fish]

Heres how you could do it for today. Just replace today() with your index match presuming it returns the date

=TEXT(TODAY(),"d-m-y")

 

[Bravo33]

Steve, Many thanks...works a treat!