Hello everyone !

I have records with multiples Date fields (4 fields to be exactly). So we have {date field 1},{date field 2},{date field 3} and {date field 4}.


I would like to have a formula field that shows only the year of one of these date field. Something like "If {date field 1} has no date, check {date field 2}. If not, check {date field 3}. If not, {date field 4}. If not, keep the cell empty.

I tried some of formulas, without sucess.

Thank you so much for your help!

Quentin