I have 2 columns w/ dates, copied over from a different spreadsheet. I am
trying to get the latter of the two dates to appear in a third column.
Sometimes there is no date, so the field is blank.

To find the latter date, I am using the formula:

=IF(AND(C2="",D2=""),"",IF(D2C2,D2,C2))

In a few cases, C2 comes up as later when it shouldn't.

Ideas appreciated. Thanks.