Using Dates as a Qualifier for Information

[Ronnie9285]

Hello,

I am sure this is more simple than I realize. But I have two columns of dates. I have created a third column and I want to produce in a third column the date which is the most recent. For instance,

8/13/2018 08/13/2018
8/20/2012
6/1/2016 02/01/2017
3/13/2014
4/9/2010
1/14/2019
4/11/2011
6/1/2012
6/21/2009
9/28/2012 08/21/2017

In the above. I have instances where someone was originally hired of 6/1/2016 and then rehired on 2/01/2017 and I want to put in a third column the date that was the most recent. What statement can I use for it to look at both dates and show the most recent date in the remaining column, even if it one of the two original columns are blank. I am using google sheets, but assume it is a very similar formula as Excel. Any help would be ideal.

Thanks,

Ronnie

[tanasedn]

Hi,

In C1 insert:

Please Login or Register  to view this content.

[63falcondude]

As long as the dates are not being seen as text, but rather actual dates, you can use the MAX function to do this.

The maximum value of the two dates (which are stored as numbers in Excel) will be the most recent date.

[Kaper]

Added comment - if it's google sheets make sure the cell with formula is automatically formatted as a date (in excel it is).

If there is possibility of two empty cells, I'd add an if function to deal with that and don't show Jan 00 1900
Assuming the dates are in cells a1 and b1 it would read:

Please Login or Register  to view this content.

[Ronnie9285]

Perfection. That worked. Sorry for the novice question.