Years in a Rank?

Options

What formula would you use to count how many years someone has been in a rank. For example they are hired on 11/1/10 & became a professor on 10/31/11 but was a visiting professor from 11/1/10 to 10/31/11?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!