Need to compare dates between two columns and choose the later date

Ally C

Hello, I'm trying to figure out how to write a formula to compare the dates in two different columns and populate a third column with the later of the two dates.

bisaacs

Hey @Ally C,

I would just use an IF statement in the third date column to compare the dates:

=IF([Date 1]@row > [Date 2]@row, [Date 1]@row, [Date 2]@row)

Hope this helps!

Ally C

Perfect! I'd tried something similar and had checked that both columns were formatted as dates but I overlooked the obvious which was to format the third column as a date.

Your formula works perfectly and made me step back and troubleshoot.

Thanks!