I have a SharePoint list in Office 365 environment that (among other columns) has two DATE columns, how would I create another calculated column that would have the most recent date from those two Date columns.
Example:
ID Date1 Date2
1 1/1/2016 2/1/2016
2 2/1/2016 1/1/2016
3 5/1/2016 5/1/2016
I wanted my results to look like
ID MostRecentDate(Calculated Column)
1 2/1/2016
2 2/1/2016
3 5/1/2016
My environment is SharePoint Online.