Employee Tenure Based On Hire Date

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.  

Best Answer

  • AS
    AS 🔵
    Answer ✓

    This is what we use for tenure in years:



    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"


  • 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!