Need Excel to Stop Counting Years of Service for Termed Employees

[JHawks8221]

Good Morning,

I've been browsing the forum and I'm having difficulty trying to find an answer to what I am trying to do with my workbook. I'm sure it's a very simple answer, but I'm hoping someone may be able to help me please.

I have an attendance chart that also calculates how long an employee has been with our company using the formula: =DATEDIF(E10,$U$4,"Y") in my H Cell.

I am putting the employment termination date in my F column. So, if Column F has a value in it, I'd like to have the formula in my H cell stop calculations.

Any help would be tremendously appreciated. Thank-you very much and have a nice day!

 

[Joe4]

Welcome to the Board!

I an guessing cell U4 is your current date?
If so, try:

[COLOR=#333333]=DATEDIF(E10,IF(F10,F10,$U$4),"Y")[/COLOR]

 

[JHawks8221]

Yes it is. Sorry, I forgot to mention that.

 

[JHawks8221]

And that worked. Thank-you very much

 

[Joe4]

You are welcome!