Merge 2 columns with date data

[Laure]

Hi,

I'm trying to merge 2 columns (Offer Accepted Date and Offer Declined Date) included dates into only one as below (Offer Decided Date)

Person ID	Offer Accepted Date	Offer Declined Date	Offer decided date
1	20-Feb-17		20-Feb-17
2		30-Mar-17	30-Mar-17
3		30-Mar-17	30-Mar-17
4		27-Feb-17	27-Feb-17
5	03-Apr-17		03-Apr-17
6
7	23-Mar-17		23-Mar-17

I tried to use formula if or transpose with no success. Any idea what can be the right process?

thanks a lot

[patrick_digan · Accepted solution]

@Laure Does this formula work for Offer Decided Date:

Max([Offer Accepted Date],[Offer Declined Date])

Let me know if something about your data doesn't work with that formula. You can also use If statements trying to find null/empty values, but the Max formula is a nice shortcut sometimes.

[Laure]

Hi Patrick,

Thanks a lot, it works perfectly well!