Returning Max Date

I’m trying to create a formula that returns the max date in a row with three date columns. Some of these dates are the same, so the max date formual returns 1/0/1900. I want the latest date in each row. Here are the dates:

11/1/2014 11/1/2014 10/27/2014
9/6/2015 10/1/2015 10/1/2015
5/30/2015 5/30/2015 5/28/2015
11/12/2014 11/12/2014 11/6/2014
10/22/2014 10/22/2014 10/22/2014
10/31/2014 10/31/2014 10/22/2014
9/10/2016 9/10/2016 11/23/2017

By: Zack

Leave a Reply

Your email address will not be published. Required fields are marked *