Hi
I am trying to find the closest contact date after a given referral date. It is based on a specific ID for each person. As you can see below, the sample I am trying to work it out for is all for one ID. I need a formula to brink back the first Contact Date AFTER the referral date which in this case is:
Ref date: 19/07/2015 04:21
I have added the column of referral date minus the contact date and if this is used, it will need to be the MAX of the negative values.
Any help would be very much appreciated.
<TBODY>
</TBODY><COLGROUP><COL><COL span=2></COLGROUP>
I am trying to find the closest contact date after a given referral date. It is based on a specific ID for each person. As you can see below, the sample I am trying to work it out for is all for one ID. I need a formula to brink back the first Contact Date AFTER the referral date which in this case is:
Ref date: 19/07/2015 04:21
I have added the column of referral date minus the contact date and if this is used, it will need to be the MAX of the negative values.
Any help would be very much appreciated.
ID</SPAN> | Contact Dates</SPAN> | Ref date-Contact Date</SPAN> |
813013</SPAN> | 08/07/2015 21:10</SPAN> | 10.29930556</SPAN> |
813013</SPAN> | 10/07/2015 13:31</SPAN> | 8.618055556</SPAN> |
813013</SPAN> | 19/07/2015 17:40</SPAN> | -0.554861111</SPAN> |
813013</SPAN> | 20/07/2015 12:00</SPAN> | -1.31875</SPAN> |
813013</SPAN> | 30/07/2015 11:10</SPAN> | -11.28402778 </SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL span=2></COLGROUP>