Find Latest Date between the columns!!!

Question

Hi All,

Dates are given in four difference columns, I want to find latest date on those fields. Please advise me how to find that.

Date1Date2Date3Date4 Latest Date6/14/20246/4/20246/9/20246/11/2024 6/14/20246/2/20246/12/20246/9/20246/7/2024 6/12/20246/5/20246/7/20245/31/20246/10/2024 6/10/20245/29/20246/3/20246/8/20246/5/2024 6/8/2024

Qiu · Answer

@Dhilip_Kumar 
We can also use this a bit dynamic approach in case the number of columns would change.

Spoiler

0615-Dhilip_Kumar.yxmd

alexnajm · Answer

No worries - if you could mark the post then as a solution, that would be great!

Dhilip_Kumar · Answer

@alexnajm Thank You so much!!!!. It works...