Return MIN value from date ranges - ignoring 01/01/1970

Hi all

I've got several columns with calculated dates and I wish to return the lowest value.
Is there a way to ignore the 01.01.1970 dates in the formula? I am already trying to ignore it with a IF formula which obviously doesn't seem to work.

Any ideas?

Example workbook:
Orders_example.xlsx

Thanks

orders.PNG

Try ...

=MIN(IF([@[Orders Service A]]<>0,[@[Service A First Order]],IF([@[Orders Service B]]<>0,[@[Service B First Order]],IF([@[Orders Service C]]<>0,[@[Service C First Order]],""))))

Enter with Ctrl+Shift+Enter

If its just the date 01.01.1970, you can also try to use the LEAST-Function

=LEAST(C:C,2)

Excellent! I forgot the "" at the end for the empty value!
Thanks!