Make formula return date instead of value

[Jyggalag]

Hi all,

I have this very complex formula:

It returns a date value from a different sheet. However, it is returned in a number format, rather than a date format.

Any idea how to fix this? I believe that I can use the TEXT() formula, but I cannot figure out how

If anybody can help me please let me know!

here is the full formula:

=IF($B3="","",IFERROR(INDEX(INDIRECT("'"&$E3&"'!$E$3:$E$75"),MATCH(1, (INDIRECT("'"&$E3&"'!$A$3:$A$75")=$B3)*(INDIRECT("'"&$E3&"'!$C$3:$C$75")=$E3),0)),""))

 

[BSALV]

a quick guess
=IF($B3="","",IFERROR(text(INDEX(INDIRECT("'"&$E3&"'!$E$3:$E$75"),MATCH(1, (INDIRECT("'"&$E3&"'!$A$3:$A$75")=$B3)*(INDIRECT("'"&$E3&"'!$C$3:$C$75")=$E3),0),"dd.mm.yy")),""))

 

[Jyggalag]

a quick guess
=IF($B3="","",IFERROR(text(INDEX(INDIRECT("'"&$E3&"'!$E$3:$E$75"),MATCH(1, (INDIRECT("'"&$E3&"'!$A$3:$A$75")=$B3)*(INDIRECT("'"&$E3&"'!$C$3:$C$75")=$E3),0),"dd.mm.yy")),""))

Thank you so much BSALV!! It worked out Much appreciated :D

 

[Fluff]

Why not leave it as a date, rather than converting it to text? Dates should generally be left as such.