Please help. I have a column called "Code" and three date headings as shown below.
If the code is 03, 04, or 05, I want the result to be the later date of Date 3 or Date 2, otherwise I would want the earlier date to appear. If both are blank then Date 1 should be used.
<tbody>
</tbody>
If the code is 03, 04, or 05, I want the result to be the later date of Date 3 or Date 2, otherwise I would want the earlier date to appear. If both are blank then Date 1 should be used.
Code | Date 1 | Date 2 | Date 3 | Result |
A1 | 6/11/2013 | 2/5/2014 | 3/15/2013 | 3/15/2013 |
05 | 6/25/2013 | 1/17/2014 | 5/21/2014 | 5/21/2014 |
04 | 11/13/2012 | 11/13/2012 | ||
07 | 12/18/2012 | 1/17/2013 | 1/17/2013 |
<tbody>
</tbody>