Name | Hire Date | Separation Date | Qualify |
Agustin | 7/16/2014 | Num | |
Aldo | 3/17/2014 | 1/21/2018 | No |
Ibrahim | 1/21/2017 | 1/7/2018 | No |
Luis | 8/2/2017 | 9/3/2017 | No |
Issaha | 9/28/2016 | 11/20/2016 | No |
John | 2/1/2017 | 9/5/2017 | Yes |
Arton | 5/17/2017 | Num |
<tbody>
</tbody>
Hope someone can point me in the right direction. I'm a relative novice with excel but I'm better than the next guy at work so I've been given the simple task of creating a list of employees hired in 2017 that were employed with the firm for more than 90 days and would qualify for certain benefits. Above is a small list taken from a much larger sheet. I've inserted the formula:
IF(AND(ISNUMBER(C2),B2>=DATE(2017,1,1),DATEDIF(EOMONTH(B2,0)+1,C2,"d")>90),"Yes","No") |
<tbody>
</tbody>
under the "Qualify" column, it works except when the employee does not have a separation date since they're still employeed with the firm, my formula kicks out a #NUM message. And advice?