Calculate Tenure with Several Variables

[mminchev]

I am trying to create a formula that answers the following question:

What is the Tenure at the end of 2018 (12/31/2018) for a person that has a HIRED DATE before 12/31/2018 and has a TERMINATION DATE that is either within or after 2018.

I really appreciate the help, I just cant get the calculation right. FILE IS ATTACHED.

Thank you

 

[Joe4]

Isn't it just:

=MIN(B2,C2)-A2

 

[mminchev]

Isn't it just:

=MIN(B2,C2)-A2

You are absolutely right, I am over here creating IF Statements with 4 or 5 variables, overlooking simple calculations. Thank you sir!

 

[Joe4]

You are welcome.
Glad I was able to help!