September 19, 2020
I'm trying to figure out the tenure of my employees, both current and those who are terminated. =DATEDIF(A2,B2,"m") is working for those with a hire date and termination date. I get #NUM! when there is no termination date. I was thinking an IF or OR function could be added with =DATEDIF(date1,NOW,unit) to link the two formulas. However, it just errors out on me. Any help with this would be greatly appreciated. I've attached the spreadsheet with the data.