How to pick the non null date from multiple date fields?

Hello

I have several date fields Date1, Date2, Date3, etc

For each record, I want to calculate the first non null date in that order: Date1, Date2, Date3.

So basically:

• if Date1 and Date3 are null, it should calculate Date2
• if Date2 is null, it should calculate Date1

etc

Thanks!