Trying to compare two dates and see if they occurred within 15 days of each other. What I have tried so far:
=if(I3>=15,"Yes","No") that was pointless
then I tried
=if(J3-I3>=15,"Yes","No") still not working
Here is a sample of the data:
<colgroup><col><col></colgroup><tbody>
</tbody>Some dates are blank because actions have not been completed yet.
Thanks in advance
-JR
=if(I3>=15,"Yes","No") that was pointless
then I tried
=if(J3-I3>=15,"Yes","No") still not working
Here is a sample of the data:
12/26/2018 0:00 | 12/26/2018 9:03 |
12/27/2018 0:00 | 12/26/2018 8:15 |
12/28/2018 0:00 | 12/26/2018 9:01 |
12/29/2018 0:00 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks in advance
-JR