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
Solved! Go to 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.
Hi Patrick,
Thanks a lot, it works perfectly well!