Looking for the longest date from 4 columns

hi all,

I am looking for a formula to get the longest date from 4 columns (column "c" up to column "f"). please provide a formula that can be used for this. thank you in advance.

the example attached.


regard,

dolphino

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

but zerro must be hide by format "MM/DD/YYYY;;"

hi BMV

thank you for your information. the formula running correctly


regard,
dolphino