Return value from 3 variable columns

First post, yay

Tried searching for something similar but couldn't find it.

I have a set of data where I got three columns where I got dates, now the problem is that the data varies it can be in Col A, B or C: if the date is written in Col A then B and C contains other data (text) and same rule applies for the other columns: if the date is in B, A and C will have other text.

Now I dont need the text but i want the date collected in one single column. Any ideas what to do?

Originally Posted by Fotis1991

Perhaps..

=IF(ISNUMBER(A1);A1;IF(ISNUMBER(B1);B1;IF(ISNUMBER(C1);C1;"")))

Works like a charm. Thank you very much!