I am trying to set up a spreadsheet for the years of service our employees Have served with our company. We have one person who resigned and was Rehired, twice. Below is the formula i used for employees who were hired and Are still currently working for the company. Try the same =DATEDIF(B27,C27,"Y")&"YEARS,"&DATEDIF(B27,C27,"YM ")&MONTHS,"&DATEDIF(B27,C27,"MD")&"DAYS". Please help me edit my formula for the employee who has come and gone Several times. These are the dates this employee has served with the company.
- 02/01/88 - 05/06/88
- 01/15/89 - 06/15/06
- 02/01/99 - PRESENT
Bookmarks