Forum Discussion

JaclynSchlipp's avatar
JaclynSchlipp
Qrew Member
5 years ago

Calculate contract length

I am trying to calculate the length of a contract using the start date and end date of the contract. I have a field for contract length (years) and a field for contract length (months). We do have ...
Formulas and functions
PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago
I'm not entirely sure I understand your first question.  Are you looking to calculate the contract for years and months for the 4 year contracts?

For your second question:

Month(End Date) - Month(Start Date)

------------------------------
Paul Peterson
------------------------------
  • JaclynSchlipp's avatar
    JaclynSchlipp
    Qrew Member
    5 years ago

    Hi Paul,

    I need to calculate lengths for all contracts.  The 4-year contract was just an example. 

    Scenerio 1:
    Contracts have an appointment term based off of an academic year (Aug - May). There can be 1 -6 year terms per faculty. We are manually entering an appointment start date (08/01) and appointment end date (5/31) into QB and would like to have a field that calculates the lengths per dates of appointment. 

    Scenerio 2:
    Contracts have an appointment term based off a 12-month year (Aug - Jul ; Jul - Jun; Oct - Sep; etc). 

    Scenerio 3:
    Contracts have an appointment term of less than a year (Aug - Dec; May - July; Sep - Jul; etc).

    Thanks!

    Jackie

     



    ------------------------------
    Jaclyn Schlipp
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      5 years ago
      Let's see if I have a better grasp now.

      You need three calculations.  

      One is based on a school year and you need to calculate the number of years remaining.  The next one is a multi-year contract based on a rolling calendar.  And the last is set for a given number of months.  Is that how you want the calculations?

      ------------------------------
      Paul Peterson
      ------------------------------
      • JaclynSchlipp's avatar
        JaclynSchlipp
        Qrew Member
        5 years ago
        Yes, you got it. 

        To make it a bit clearer:

        1) Academic Year contract: Aug - May (how many years appointed per term of contract 1,2,3,4,5,or 6)
        2) Academic Semester contract: Jan - May (spring) or Aug - Dec (fall); term will always be 5 months
        3) 12-Month contract: the annualization factor is 12 so the less than 1-year appointments (non-academic) can fit here

        Hope this helps.






        ------------------------------
        Jaclyn Schlipp
        ------------------------------