Pull Last Date from 4 Different Date Columns

[mattross19]

I have four different date columns. They won't all be populated, but I'm trying to add a new column to the dataset that will look at those four date fields to assess the values in those columns (if more than 1) to determine what is the last date. 

Is there a formula I could create to pull that last date value into a new column? 

[rsbin · Accepted solution]

@mattross19 ,

Please see if this works for you.  Create a new Calculated Column:

MaxDate = MAX([4], ( MAX( [3], ( MAX( [1], [2] )))))

1                                     2                                       3                                  4                                        MaxDate

Tuesday, February 1, 2022	Tuesday, February 15, 2022	Monday, March 14, 2022	Sunday, April 10, 2022	4/10/2022 12:00:00 AM
Tuesday, March 1, 2022		Friday, July 1, 2022	Wednesday, June 1, 2022	7/1/2022 12:00:00 AM

Regards,