What is the Beast Mode Formula for calculating employee tenure using their Hire Date? I am trying to create a card that shows average tenure per office.
This is what we use for tenure in years:
You could do something like this:
DateDiff using Current_Date and Hire Date will give you the # of days each employee has been employeed. Averaging that by office should give you what you're looking for.
Hope that helps,
**Please mark "Accept as Solution" if this post solves your problem**Say "Thanks" by clicking the "heart" in the post that helped you.
Thank you! That worked!